PG Phriday Archives - Page 3 of 3 - 2ndQuadrant

Posts

PG Phriday: Crazy Correlated Column Crusade

July 14, 2017/4 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

For a long time, the Postgres query planner has sported a huge blinking neon blind-spot that frustrated and enraged DBAs throughout the universe to a level just shy of murderous frenzy. How is this even possible? What terrible lurking horror could elicit such a visceral response from probably the most boring and straight-laced people ever […]

PG Phriday: Uptown Func

June 30, 2017/5 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

One of the coolest things about Postgres functions is that they can return rows as if they were a table. Not only is it possible, but creating a set-returning function in Postgres is almost frighteningly trivial when compared to other database engines. In fact, some Oracle users are probably rolling their eyes and muttering “Just […]

PG Phriday: Postgres on Tap

June 16, 2017/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

Testing within the context of a database can sometimes seem a bit overwhelming. Not only is it necessary to create a reasonable set of test data to bootstrap multiple tables, but we need some reliable invocation system to compare query, view, and function output to expected results. And that is no small feat. For a […]

PG Phriday: Dearly De-parted

June 9, 2017/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

With the christening of PG Phriday at its new location, it’s only fitting that we revisit a frequent boon and bane of organized storage: partitioning. When volume and scale reach a certain point that the very laws of physics become a barrier to efficiency, partitions are a crucial tool to escape the otherwise inevitable pile […]

2ndQuadrant is now part of EDB

Posts

PG Phriday: Crazy Correlated Column Crusade

PG Phriday: Uptown Func

PG Phriday: Postgres on Tap

PG Phriday: Dearly De-parted

Support & Services

Products

Postgres Learning Center

About Us