Re: how to slow down parts of Pg - Mailing list pgsql-general

From Michael Lewis
Subject Re: how to slow down parts of Pg
Date
Msg-id CAHOFxGo_+iyx-MOqmF6gfJNmdfM=dTBY5EcO4RjEhGxuLs8azQ@mail.gmail.com
Whole thread Raw
In response to how to slow down parts of Pg  (Kevin Brannen <KBrannen@efji.com>)
Responses RE: how to slow down parts of Pg
List pgsql-general
You say 12.2 is in testing but what are you using now? Have you tuned configs much? Would you be able to implement partitioning such that your deletes become truncates or simply a detaching of the old partition? Generally if you are doing a vacuum full, you perhaps need to tune autovacuum to be more aggressive. Consider pg_repack at least to avoid taking an exclusive lock for the entire duration. If partitioning is not an option, could you delete old records hourly rather than daily?

pgsql-general by date:

Previous
From: Kevin Brannen
Date:
Subject: how to slow down parts of Pg
Next
From: Michael Loftis
Date:
Subject: Re: how to slow down parts of Pg