Re: [ADMIN] partitioning system tables

2013-10-04 Thread Albe Laurenz
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 per

Re: [ADMIN] partitioning system tables

2013-10-02 Thread David Johnston
Radovan Jablonovsky wrote > Hello, > > 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 im

[ADMIN] partitioning system tables

2013-10-02 Thread Radovan Jablonovsky
Hello, 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?