Re: partitioning system tables - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: partitioning system tables
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17C276CB@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to partitioning system tables  (Radovan Jablonovsky <radovan.jablonovsky@replicon.com>)
List pgsql-admin
Radovan Jablonovsky wrote:
> When postgresql system tables, (tables in pg_catalog) reach size of 10mil rows, it will slow down some
> DDL operations, which insert, update or delete data from pg_* tables. Is it possible to partition the
> system tables or is there some other way to improve performance of the DDL operations?

You can't do that.

I think the problem you should address is why there are so many rows
in a catalog table.  10 million is an awful lot.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: "Rajagopalan, Jayashree"
Date:
Subject: Re: postgres connections in IDLE state..
Next
From: Mike Broers
Date:
Subject: ERROR: could not open file "base/125542/12631" Corruption?