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 236 — December 13, 2017
Reducing Disk Bloat with pg_repack
An extension for removing ‘bloat’ from tables & indexes without taking exclusive locks.
Knut Ingvald Dietzel
PGCon 2018 Call for Papers Now Open
The conference will take place on 29 May - 1 June at the University of Ottawa. Deadline for submissions is 19 Jan 2018.
PGCon   #news 
There's One Big Reason That Postgres Can't Kill Oracle
PG is popular but can’t unseat Oracle which continues to thrive with its contracts and ‘stickiness’.
Matt Asay   #opinion 
Get the Health of Your PostgreSQL Database Checked by 2ndQuadrant Experts
Prevention is better than a cure. The same is true for your PostgreSQL database. Our experts examine many aspects of your databases and determine the overall health in areas like performance, security, data loads, availability and compliance.
2ndQuadrant PostgreSQL Services    #sponsored 
Performance Best Practices for Using Azure Database for Postgres
At Build 2017, Microsoft announced the preview of Azure Database services for PostgreSQL, a simple, fully managed PostgreSQL database service. Here are some tips for working with it.
Amit Banerjee   #news 
'IS DISTINCT FROM': For Treating Two NULLs As Equivalent
In SQL null = null isn’t true. Postgres’s support for IS NOT DISTINCT FROM helps when you need to make null-aware comparisons.
Markus Winand
Adding Unsigned 256 Bit Integers in Postgres
It’s possible with the pg-bignum library.
Stack Exchange
Using Postgres Arrays from Go(lang)
RapidLoop
How We Built a PostgreSQL Cluster in a Box
The ‘box’ is quite literal, too. The tech leant on Patroni, an open source tool for building highly available clusters.
Cybertec
If Postgres Used Threads Instead of Processes..?
A technical post covering how a developer created a simple prototype for some basic benchmarks, but the reaction was lukewarm.
Konstantin Knizhnik
Queen, Princesses, and Workers
A proposal for clarifying the terminology around ‘primary’ and ‘standby’ servers in complex Postgres setups.
Dimitri Fontaine   #opinion 
Chart Your Course to Become a Postgres Expert
Demand for skilled Postgres resources is exceeding supply. Invest in your career. Get EDB Postgres Certified.
EnterpriseDB    #sponsored 
PostgreSQL PHP Generator Lite Released
A commercial Windows app for creating PHP & PG-backed sites without any coding needed.
SQL Maestro Group   #tools 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.