Re: loading increase into huge table with 50.000.000 records

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: loading increase into huge table with 50.000.000 records
Дата
Msg-id 44C79ACB.5010507@logix-tt.com
обсуждение исходный текст
Ответ на Re: loading increase into huge table with 50.000.000 records  (Sven Geisler <sgeisler@aeccom.com>)
Список pgsql-performance
Дерево обсуждения 
Hi, Larry,
Hi, Sven,

Sven Geisler wrote:

> You can increase wal_buffers, checkpoint_segments and checkpoint_timeout
> much higher.

You also should increase the free space map settings, it must be large
enough to cope with your weekly bunch.


Markus


--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

В списке pgsql-performance по дате отправления:

Предыдущее
От: Sven Geisler
Дата:
Сообщение: Re: loading increase into huge table with 50.000.000 records
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: loading increase into huge table with 50.000.000 records