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