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

From: Rick Otten <rottenwindfish(at)gmail(dot)com>
To: Lars Aksel Opsahl <Lars(dot)Opsahl(at)nibio(dot)no>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL and a Catch-22 Issue related to dead rows
Date: 2024-12-09 14:25:45
Message-ID: CAMAYy4J3TEMKjbs4imE1iqPNDmi2ZCRUm0aZtcsvFNRxgQLqOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christophe Pettus 2024-12-09 14:32:59 Re: PostgreSQL and a Catch-22 Issue related to dead rows
Previous Message Lars Aksel Opsahl 2024-12-09 13:56:54 Re: PostgreSQL and a Catch-22 Issue related to dead rows