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 235 — December 6, 2017
Postgres 11 Adding Support for 'SQL Procedures'
Work on the next major version of Postgres is ongoing and the latest addition is support for SQL procedures, as supported in Oracle and SQL Server.
Peter Eisentraut   #news 
Analyzing Millions of Postgres Query Plans
Analytics tool Heap handles a dynamic schema that isn’t fully known until read time. Here’s how they use Postgres extension auto_explain for figuring out why any queries are slow.
Michael Malis
Demystifying Postgres Logical Replication
Logical decoding was added in Postgres 9.4, and it continues to improve due to the vibrant open source community. In this webinar, we'll be walking through its concepts, usage and some of the new things coming in future releases.
Percona    #sponsored 
Adding a NOT NULL CONSTRAINT on PG Faster with Minimal Locking
Constraints on your data are useful to ensure correctness, but adding them can sometimes come at a cost. This guidance helps makes the process cleaner.
Christophe Escobar
PostgreSQL Exercises
If you’re looking for a way to practice your SQL skills, PG Exercises offers some good example data and exercises to hone your skills.
Alisdair Owens   #tools 
Amazon RDS Now Supports Database Storage Sizes up to 16TB
RDS has increased the max storage size from 6 TB now up to 16 TB for a single instance.
Amazon Web Services   #news 
Amazon RDS and Aurora: The Golden Arches of Postgres?
“Amazon RDS and the elasticity of Aurora are great additions to core capabilities of Postgres. But what are the trade-offs for these benefits and how do they affect other Postgres capabilities?”
Keith Alsheimer, CMO of EnterpriseDB   #opinion 
Scaling Postgres: Load Balancing and Healthchecks
Running your own Postgres database but need some automation around scaling and monitoring? Here’s a look at one setup and how they’ve configured things to keep scaling.
Marco Almeida
A Guide for Customer Retention Analysis with SQL
A great run through of some moderately complex, but very useful SQL for analyzing retention data of customers.
Luba Belokon
Linux Cloud Hosting Starting at 1GB of RAM for $5/mo
Get a Linode server up and running in seconds. Get a $20 credit on a new account.
Linode Cloud Hosting    #sponsored 
pg_hexedit: Rich Hex Editor Annotations for Postgres Relfiles
An experimental tool for looking at Postgres’ relation files in a hex editor with annotations/tags and tooltips that show what’s going on.
Peter Geoghegan   #tools 
check_pgactivity 2.3: A Postgres Plugin for Nagios
Now with complete Postgres 10 support.
github.​com   #tools 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.