Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 242 — February 7, 2018
Standard SQL Features Where Postgres Beats Its Competitors
Code-heavy slides from a talk given at FOSDEM PgDay that cover filters, BOOLEAN tests, XMLTABLE, and inverse distribution functions.
Markus Winand
Postgres's Hidden Gems
A collection of responses to the question: “Whats your favorite hidden gem of Postgres that you wish more people knew about?”
Craig Kerstiens   #opinion 
PostgresConf US 2018: The Largest Postgres Conference Series in the World
Happening April 16 - 20 at the Westin Jersey City Newport, we will be featuring two full days of Postgres training opportunities, three days of breakout session content, a large sponsor hall, numerous workshops, a job fair, and more. Register today.
PostgresConf.​org    #sponsored 
Find The Longest Continuous Number of Days a Stock Went Up
We all love a good, thorough SQL tutorial, right? This is a great walkthrough of bringing together several SQL features in a relatively advanced way.
Dimitri Fontaine
Postgres Indexing: Index vs. Bitmap vs. Sequential Scans
A quick intro to index scans in Postgres, highlighting what the optimizer does when a single query is processed.
Hans-Jürgen Schönig
Exporting a Hierarchy in JSON with Recursive Queries
Putting JSON into Postgres is pretty simple nowadays, but exporting it in elaborate ways can require a bit of work as in this example.
Dimitri Fontaine
Demystifying Contributing to Postgres
Want to contribute some code, a patch, even some documentation? Here’s a talk covering how to get involved. (See links to the slides and video at the bottom of the page.)
Lætitia Avrot
SelectStar: One Monitoring Solution to Cover All Your (Data)bases
SelectStar    #sponsored 
How The Citus Distributed Database Rebalances Your Data
Citus is an extension for scaling Postgres horizontally.
citusdata
How Updating A Partition Key Would Work in Postgres 11
Stefan Fercot
Easily Setup Postgres 10 and pgAdmin 4 with Docker
Jonathan S.​ Katz
Creating Fast, Lightweight Testing Databases in Docker
Kevin Barresi
Postgres Tip: Working With Dates Using the EXTRACT Function
Karol Galanciak
Linux Cloud Hosting Starting at 1GB of RAM for $5/mo
Linode Cloud Hosting    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.