Re: PostgreSQL and a Catch-22 Issue related to dead rows - Mailing list pgsql-performance

From Rick Otten
Subject Re: PostgreSQL and a Catch-22 Issue related to dead rows
Date
Msg-id CAMAYy4J3TEMKjbs4imE1iqPNDmi2ZCRUm0aZtcsvFNRxgQLqOA@mail.gmail.com
Whole thread Raw
In response to PostgreSQL and a Catch-22 Issue related to dead rows  (Lars Aksel Opsahl <Lars.Opsahl@nibio.no>)
Responses Re: PostgreSQL and a Catch-22 Issue related to dead rows
List 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 by date:

Previous
From: Lars Aksel Opsahl
Date:
Subject: Re: PostgreSQL and a Catch-22 Issue related to dead rows
Next
From: Christophe Pettus
Date:
Subject: Re: PostgreSQL and a Catch-22 Issue related to dead rows