Hi guys,
We have a Java process that uses Hibernate to load approximately 14 GB of
data. One a dual-proc 2.4 GHZ Xeon with 2048 MB RAM, it's currently
taking over 13 hours to load (PostgreSQL 7.4.8). We're flushing from
hibernate every 50 records.
I've turned fsync to false in postgresql.conf, and we've turned autocommit
off in our code. Is there anything else I could try to temporarily speed
up inserts?
Thanks very much for your help.
John