No I don't, but definitely will try tomorrow > Excerpts from wstrzalka's message of jue ago 26 03:18:36 -0400 2010: >> So after turning off fsync & synchronous_commit (which I can afford as >> I'm populating database from scratch) >> I've stucked at 43 minutes for the mentioned table. There is no PK, >> constrains, indexes, ... - nothing except for data. > Are you truncating the table in the same transaction that copies the > data into it? If you do that, an optimization to skip WAL fires getting > you a nice performance boost. You need to have WAL archiving turned off > though. > Also, if you do that, perhaps there's no point in turning off fsync and > synch_commit because an fsync will be done only once when the copy is > complete. -- Pozdrowienia, Wojciech Strzałka -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
