Archive for May, 2007

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

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