The idea of ‘horizontal scalability’ was discussed in great detail at PGCon 2014 in Ottawa this year. It is great to see the community discussing ideas on how PostgreSQL can...
That famous journey began simply—just follow the yellow brick road. But as we all learned, that pretty little lane entered some pretty challenging territory pretty quickly.
Pay a visit to Pit Row at a race like the Daytona 500 and you’ll find teams crawling around the stock cars carrying bolt blasters, socket wrenches and super-sensitive listening...
TL;DR: Reduce planned database down times by about 97%, by using Postgres Hibernator. DBAs are often faced with the task of performing some maintenance on their database server(s) which requires...
Last week, I attended the Linux Storage, Filesystems, and Memory Management summit (LSF/MM) on Monday and Tuesday, and the Linux Collaboration Summit (aka Collab) from Wednesday through Friday.
In two weeks, I'm headed to LSF/MM and the Linux Collaboration Summit, by invitation of some Linux kernel hackers, to discuss how the Linux kernel can better interoperate with PostgreSQL...
A special presentation of EnterpriseDB’s Introduction to PostgreSQL Administration next month will be led by PostgreSQL community leader and Global Development Group co-founder Bruce Momjian. The three-day live virtual event...
Postgres' parameters have an associated context, which determines when that parameter can be changed. You can see the context of every parameter using the following query. A sample output is...