Re: PostgreSQL and a Catch-22 Issue related to dead rows

Поиск
Список
Период
Сортировка
От Rick Otten
Тема Re: PostgreSQL and a Catch-22 Issue related to dead rows
Дата
Msg-id CAMAYy4J3TEMKjbs4imE1iqPNDmi2ZCRUm0aZtcsvFNRxgQLqOA@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL and a Catch-22 Issue related to dead rows  (Lars Aksel Opsahl <Lars.Opsahl@nibio.no>)
Ответы Re: PostgreSQL and a Catch-22 Issue related to dead rows
Список pgsql-performance

Yes there are very good reason for the way removal for dead rows work now, but is there any chance of adding an option when creating table to disable this behavior for instance for unlogged tables ?



Are you saying your job is I/O bound (not memory or cpu).  And that you can only improve I/O performance by committing more frequently because the commit removes dead tuples which you have no other means to clear?   Is your WAL already on your fastest disk?

All of your parallel jobs are operating on the same set of rows?  So partitioning the table wouldn't help?
 

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