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. -- Álvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
