On 18th of March, Alvaro Herrera committed patch: array_offset() and array_offsets() These functions return the offset position or positions of a value in an array. Author: Pavel Stěhule Reviewed by: Jim Nasby

One of my clients is upgrading some servers. The procedure we have took some time to get to current state, and we found some potential problems, so decided to write more about it.

On 23rd of February, Heikki Linnakangas committed patch: Replace checkpoint_segments with min_wal_size and max_wal_size. Instead of having a single knob (checkpoint_segments) that both triggers checkpoints, and determines how many checkpoints to recycle, they are now separate concerns. There is still an internal variable called CheckpointSegments, ...

I had to deal with this question, or some version of it, quite a few times. So, decided to write a summary on what one could (or should) do, after data is in database, and application is running. Namely - ...

February 4th, 2015 by depesz | Tags: , , , | 5 comments »

I was working today on some updates to client database. While doing it, I figured it would be simpler if I saw all "codenames" and ids of rows from dictionary table - not so big. But it was bigger than ...

February 3rd, 2015 by depesz | Tags: , , , , , , | No comments »

Just thought I'll share a "fun" story. Friend reported weird bug - OmniPITR reported that xlogs are sent to archive, but they actually weren't. After some checking we found out that he was giving custom rsync-path (--rsync-path - path to rsync ...

On 19th of January, Robert Haas committed patch: Use abbreviated keys for faster sorting of text datums. This commit extends the SortSupport infrastructure to allow operator classes the option to provide abbreviated representations of Datums; in the case of text, we abbreviate by taking ...

On 23rd of January, Alvaro Herrera committed patch: vacuumdb: enable parallel mode This mode allows vacuumdb to open several server connections to vacuum or analyze several tables simultaneously. Author: Dilip Kumar. Some reworking by Álvaro Herrera Reviewed by: Jeff Janes, Amit Kapila, Magnus Hagander, ...

This time the changes do not modify how the website works. But they make it simpler to deploy clone of explain.depesz.com on your own server. Thanks to Petr A. Korobeinikov I got full automation for setting test/development/internal clones of the site. ...

On 15th of December, Heikki Linnakangas committed patch: Add point < -> polygon distance operator. Alexander Korotkov, reviewed by Emre Hasegeli.