Today, on irc, someone asked interesting question. Basically she ran a query like: select a, b, c, d, e, f from table order by a then, she processed the query to get, for each a array of unique values of b, c, d, ...

Quite a long time ago (in October), Oskar Liljeblad reported a bug in anonymization. Namely - group keys were not anonymized. You can see example of such plan here. I finally got to it, fixed the bug, pushed new version to live ...

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 ...

Recently I saw this discussion on LinkedIn. In there a guy asks whether modifying script while it's executing will change the way it executes.

There are some cases where you might want to get your own copy of explain.depesz.com. You might not trust me with your explains. You might want to use it without internet access. Or you just want to play with it, ...

Uploaded new version to the server - straight from GitHub. There are two changes - one visible, and one not really. The invisible change, first, is one for people hosting explain.depesz.com on their own. As you perhaps know you can get ...

Yesterday I had an interesting discussion on irc. A guy wanted to know why Perl script is causing problems when dealing with Pg and unicode characters. The discussion went sideways, I got (a bit) upset, and had to leave anyway, so I didn't finish ...

On 11th of December, Peter Eisentraut committed patch: PL/Perl: Add event trigger support From: Dimitri Fontaine

December 18th, 2013 by depesz | Tags: , , , , , , | No comments »

Right after releasing 1.3.0 I realized that I forgot about one thing. If you're using ext3 (and possibly other, not sure) file system, removal of large file can cause problems due to heavy IO traffic. We did hit this problem earlier at ...

So, I made some changes to explain.depesz.com, and while informing about it, I'd like to brag a bit about numbers, again :)