more PostgreSQL nerdliness
2000-11-03 18:41:05+01 by Dan Lyke 0 comments
Holy Cats! I just discovered how expensive autocommit in PostgreSQL is. Updating data in 1,800 records from an XML file I'm seeing a full factor of 100 from autocommits versus putting all those updates in a single transaction. Youch. This explains a lot. Wonder if there's a good way to say "these updates aren't transaction critical, do them optimally" so that I don't end up choking memory on huge updates?