Posts by: craig.ringer

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…

Testers needed for proposed 9.3 SEPostgreSQL enhancements

SELinux / SEPostgreSQL users: There are some proposed improvements in the 2013-01 commitfest that might go into…

PostgreSQL regression tests hanging on Windows? Check path depth.

I just confirmed the cause an extremely weird problem that’s been frustrating me for days. I want…

Simplifying compilation of PostgreSQL on Windows

As part of some internal continuous integration and testing work, I’ve put together some scripts to simplify…

12