Posts by: craig.ringer

PostgreSQL anti-patterns: Unnecessary json/hstore dynamic columns

PostgreSQL has json support – but you shouldn’t use it for the great majority of what you’re…

Dynamic SQL-level configuration for BDR 0.9.0

The BDR team has recently introduced support for dynamically adding new nodes to a BDR group from…

BDR for PostgreSQL: Present and future

For a couple of years now a team at 2ndQuadrant led by Andres Freund have been working…

All-processes breakpoints / watchpoints for PostgreSQL

Sometimes SELECT pg_backend_pid() and gdb‘s attach aren’t enough. You might have a variable in shared memory that’s…

Ware Yosemite? Possible PostgreSQL upgrade issues in OS X 10.10

I’m seeing reports of a number of issues with PostgreSQL after upgrades of OS X machines to…

Compiling and debugging PostgreSQL’s PgJDBC under Eclipse

I’ve always worked on PgJDBC, the JDBC Type 4 driver for PostgreSQL, with just a terminal, ant…

pg_sysdatetime: a simple cross-platform PostgreSQL extension

A while ago I wrote about compiling PostgreSQL extensions under Visual Studio – without having to recompile…

Announcing BDR RPMs for 9.4

RPMs for BDR (Bi-Directional Replication for PostgreSQL) are now available for testing. They contain BDR release 0.7.1,…

PostgreSQL anti-patterns: read-modify-write cycles

Shaun Thomas’s recent post about client-side loops as an SQL anti-pattern is well worth a read if…

keep-calm-and-take-a-hint

PostgreSQL’s CTEs are optimisation fences

As part of AXLE project work I recently found myself re-examining issues around optimisation fencing and non-semantic…

Putting a PostgreSQL tablespace on a ramdisk risks ALL your data

I periodically see people being advised to put their tablspaces on RAM disks or tempfs volumes. This…

Row security in PostgreSQL – Overview

In the next week I will be writing a series of posts about the row-security work I’ve…

Streaming replication slots in PostgreSQL 9.4

Streaming replication slots are a pending feature in PostgreSQL 9.4, as part of the logical changeset extraction…

Compiling PostgreSQL extensions with Visual Studio on Windows

I’ve seen a number of users struggling with building PostgreSQL extensions under Visual Studio, so I thought…

PostgreSQL guts: What is “resjunk”?

I’m delving into the PostgreSQL parser, query rewriter and query planner at the moment, as part of…

Security Barrier

How do PostgreSQL security_barrier views work?

You might have seen the support added for security_barrier views in PostgreSQL 9.2. I’ve been looking into…

12