Re: copy and postgresql.conf

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: copy and postgresql.conf
Дата
Msg-id 196.1140016698@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: copy and postgresql.conf  ("FERREIRA, William (VALTECH)" <william.ferreira@airbus.com>)
Список pgsql-performance
"FERREIRA, William (VALTECH)" <william.ferreira@airbus.com> writes:
> with PostgreSQL 8.1.3, here are my parameters (it's the default configuration)

> wal_sync_method = fsync
> wal_buffers = 8
> checkpoint_segments = 3
> bgwriter_lru_percent = 1.0
> bgwriter_lru_maxpages = 5
> bgwriter_all_percent = 0.333
> bgwriter_all_maxpages = 5

> and you think times can be improved again ?

Increasing checkpoint_segments will definitely help for any write-intensive
situation.  It costs you in disk space of course, as well as the time
needed for post-crash recovery.

            regards, tom lane

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

Предыдущее
От: "Jignesh K. Shah"
Дата:
Сообщение: Re: copy and postgresql.conf
Следующее
От: Antal Attila
Дата:
Сообщение: Stored proc and optimizer question