Posts by: craig.ringer

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…

Tracing PostgreSQL

Tracing PostgreSQL with perf

The profiling utility perf that ships with the Linux kernel is extremely useful for examining system-wide and…

Testing new PostgreSQL versions without messing up your existing install

People are often hesitant to test out a new PostgreSQL release because they’re concerned it’ll break their…

Choosing a PostgreSQL text search method

(This article is written with reference to PostgreSQL 9.3. If you’re using a newer version please check…

Help us make a better PostgreSQL 9.3!

As interest in PostgreSQL grows, so does the rate at which new patches are proposed. To maintain…

Cygwin users needed to test a patch for PostgreSQL 9.3

Cygwin users, If you use PostgreSQL on Cygwin, please try out this build fix, verifying that it…

12