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 по дате отправления:

Предыдущее
От: Vick Khera
Дата:
Сообщение: Re: MySQL versus Postgres
Следующее
От: Filip Rembiałkowski
Дата:
Сообщение: Re: Restore referencial integrity