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 233 — November 15, 2017

Just a quick heads up that we're taking a break for Thanksgiving next week, so the next issue will be on Wednesday, November 29. In the meantime, there's a heavy focus on ways to upgrade from Postgres 9.x to 10 this week, so if you get bored next week at all.. :-)

Upgrading From 9.6 to 10 with Minimal Downtime using pglogical
One approach of using pglogical to switch from 9.6 to 10 in ‘just a few seconds’.
Rodrigo Rosenfeld Rosas
How to Scale PG 10 with Table Inheritance & Declarative Partitioning
One of the more exciting new features in Postgres 10 is declarative partitioning. This can make it easier to scale to ‘big data’ volumes.
Timescale
Advanced SQL: A Look Through Window Functions
A thorough, Postgres-flavored exploration of window functions, ideal if you’re not particularly familiar with them.
Michal Konarski
24/7 PostgreSQL Support From the Experts That Wrote the Code
When it's critical, you can count on us. Who better to support your database around-the-clock than the experts who developed the PostgreSQL features you're using? We guarantee a quick database recovery with as little downtime as possible.
2ndQuadrant PostgreSQL Services    #sponsored 
Migrating Partitioned Tables to Postgres 10's Native Partitioning
Jobin Augustine
An Alternative Way of Upgrading to Native Partitioning
A post inspired by the one above but which takes a different approach, not involving dumping and restoring tables.
Alexey Lesovsky
PostgreSQL 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20, and 9.2.24 Released
These releases fix three security vulnerabilities, and patch a few minor bugs.
postgresql.​org   #news 
The Mode Ordered-Set Aggregate Function
A way to find the most frequent input value in a group.
Dimitri Fontaine
Postgres Primary/Replica Replication on Heroku with Ruby on Rails
Krzysztof Kempiński
Faster Bulk Loading in Postgres with 'Copy'
\copy is a mechanism for you to bulk load data in or out of Postgres.
citusdata
From 0 to ~100: Business Continuity with PostgreSQL
A run through combinations of disaster recovery and high availability processes/architectures that you can use with PostgreSQL.
Gabriele Bartolini
Linux Cloud Hosting Starting at 1GB of RAM for $5/mo
Get a Linode server up and running in seconds. Get $20 credit on a new account.
Linode Cloud Hosting    #sponsored 
OmniDB 2.3: A Browser-Based Postgres Management Tool
The new version includes a debugger for PL/pgSQL functions.
2nd Quadrant   #tools 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.