| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Radovan Jablonovsky *EXTERN*" <radovan(dot)jablonovsky(at)replicon(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: partitioning system tables |
| Date: | 2013-10-04 07:45:55 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17C276CB@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Broers | 2013-10-04 14:40:10 | ERROR: could not open file "base/125542/12631" Corruption? |
| Previous Message | Rajagopalan, Jayashree | 2013-10-03 16:34:05 | Re: postgres connections in IDLE state.. |