Archive for May, 2007
Partitioning Fun in PostgreSQL
Last week I learned a few things (the hard way) about PostgreSQL (pgsql) partitioning: You really have to read the "caveats" part of the manual (scroll down, very bottom) Server config matters (SET constraint_exclusion = on;) if you want to avoid unnecessarily checking out-of-bounds partitions Child tables don't inherit permissions, so owning the parent table won't automagically grant you access to child tables -- which in this case prevented me from setting up my explicit indexes. Foreign key constraints on a parent table are not inherited. This is actually a bug in pgsql. They plan on changing "CREATE ... Read More »
Tagging in SVN
So we decided to use SVN because it's cooler and more modern. It's not so bad, especially for webapps. We like the atomic commits, webdav, yadda yadda. You know why it's better than CVS we aren't going to regurgitate that to you. But when deploying we ran into some issues with SVN merge. If you always do updates in a batch and never have an "oh crap update this now" update then you're fine. But as we all know, stuff happens. So when we have tried to merge the entire tree after merging single files ... Read More »
