Archiwizowane June, 2010

OmniPITR project that I wrote about some time ago is going on. Just today I finished tests for omnipitr-backup-slave - part of OmniPITR which lets you make hot-backups of WAL-slave machine - without any additional load on master. As previously - please ...

Today, Mattias|farm on IRC asked how to create primary key using HASH index. After some talk, he said that in some books it said that for "=" (equality) hash indexes are better. So, I digged a bit deeper.

Every so often you might need to find a value regardless of which column it's in. Of course not in application code, as this would be very slow. But you might be in situation where you just don't know where did ...

June 22nd, 2010 by depesz | Tags: , , , | 14 comments »

Relatively soon we will have 9.0, and we will move with development to 9.1 (we as in: PostgreSQL community, I don't know C so I can't help developing myself, but I will at least try to keep up with changes ...

I have a mixed love/hate relationship with tests. I hate writing them. I hate remembering to add them when I'm in the zone, and application code is flowing freely from the tips of my fingers. But when I do add them, I ...

Every now and then there is someone on IRC, mailing lists, or private contact which asks about rules. My answer virtually always is: don't use rules. If you think that they solve your problem, think again. Why?

June 2nd, 2010 by depesz | Tags: , , , , | 16 comments »

Thanks to the company I work for OmniTI I was working on pretty cool project. Name of the project is OmniPITR, and here is what it is, why, how, and where to get it.