Re: Feature proposal
От | Wojciech Strzałka |
---|---|
Тема | Re: Feature proposal |
Дата | |
Msg-id | 824699945.20100830215101@gmail.com обсуждение исходный текст |
Ответ на | Re: Feature proposal (Alvaro Herrera <alvherre@commandprompt.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: