[sapug] Large dictionaries
Daryl.Tester at iocane.com.au
Thu May 11 11:48:03 CEST 2006
Darryl Ross wrote:
> Make sure you put any inserts into a transaction. Using a disk based
> database, inserting 10,000 rows went from being a multi-minute operation
> to a split-second operation, just by putting them inside a BEGIN/COMMIT.
This applies to a lot of databases (I'm thinking of Postgres and
Oracle in particular) - INSERTs outside of a transaction are
wrapped in their own individual transactions, instead of around
a block of 'em. I think there's an option to later Postgres' to
switch it off on a per-session basis, at least from psql.
Daryl Tester, IOCANE Pty. Ltd.
More information about the sapug