Archiwizowane December, 2010

First of all - just today I committed patch for Pg::Explain - which is the workhorse behind explain.depesz.com. This patch fixes calculation of exclusive time for explain nodes, and the best thing about it is - I didn't write it. It's ...

December 13th, 2010 by depesz | Tags: , , , , , | 6 comments »

At home I have couple of machines, but one of them takes relatively long time to login to. It looks like this: =$ time ssh blob id -u 1000   real 0m0.401s user 0m0.010s sys 0m0.000s While 0.4s ...

On 4th of December, Tom Lane committed really cool patch: KNNGIST, otherwise known as order-by-operator support for GIST. This commit represents a rather heavily editorialized version of Teodor's builtin_knngist_itself-0.8.2 and builtin_knngist_proc-0.8.1 patches. I redid the opclass API to add a separate Distance method instead ...

I use quite a lot of vpns. On any given moment I have between 3 and 10 active vpn connections from the machine I'm working on. I generally tend to use OpenVPN, but I also do use vpnc (Cisco VPN client). One ...

As you perhaps know I'm fan of pgbouncer - connection pooling solution for PostgreSQL. It can do many really cool things, but has one slight issue. Since it can reuse connections - it has to provide a way to check if user ...