Re: Is there a way to SubPartition?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is there a way to SubPartition?
Дата
Msg-id 29791.1219870443@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Is there a way to SubPartition?  ("Jerry Champlin" <jchamplin@absolute-performance.com>)
Список pgsql-performance
Дерево обсуждения 
"Jerry Champlin" <jchamplin@absolute-performance.com> writes:
> We have synchronous_commit turned off, commit siblings set to 5,
> commit_delay set to 50,000.  With synchronous_commit off does it make
> any sense to be grouping commits?

No.  In fact commit_delay is a total no-op in that mode.  If it were
doing anything I think you'd have found that to be a counterproductively
large setting ...

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Is there a way to SubPartition?
Следующее
От: david@lang.hm
Дата:
Сообщение: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception