Re: Per-Table vacuum_freeze_min_age

On Wed, Apr 6, 2022 at 6:31 PM Adrian Klaver wrote: > On 4/6/22 3:28 PM, Chris Bisnett wrote: > > On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver > > wrote: > > > > > It can: > > > > > https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE

Re: Per-Table vacuum_freeze_min_age

On 4/6/22 3:28 PM, Chris Bisnett wrote: On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver > wrote: It can: https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS

Re: Per-Table vacuum_freeze_min_age

On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver wrote: > On 4/6/22 3:13 PM, Chris Bisnett wrote: > > Hi all! > > > > I have several large tables (1-2Tb) that are 99.9% writes (small number > > of updates) with a decent commit rate (20K/sec). The basic idea is that > > it’s generating a lot of data c

Re: Per-Table vacuum_freeze_min_age

On 4/6/22 3:13 PM, Chris Bisnett wrote: Hi all! I have several large tables (1-2Tb) that are 99.9% writes (small number of updates) with a decent commit rate (20K/sec). The basic idea is that it’s generating a lot of data continuously. When the table would reach the thresholds for autovacuum

Re: Per-Table vacuum_freeze_min_age

Chris Bisnett writes: > The only downside I’ve seen is that this is a global setting and my > understanding is that this would cause decreased performance when used with > tables with a lot of writes and deletes. Is there a technical reason this > setting cannot be applied at the database or table