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?
Sincerely,
-- Radovan Jablonovsky | SaaS DBA | Phone 1-403-262-6519 (ext. 256) | Fax 1-403-233-8046
Replicon | Hassle-Free Time & Expense Management Software - 7,300 Customers - 70 Countries
www.replicon.com | facebook | twitter | blog | contact us
We are hiring! | search jobs
