partitioning system tables

From: Radovan Jablonovsky <radovan(dot)jablonovsky(at)replicon(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: partitioning system tables
Date: 2013-10-02 20:14:50
Message-ID: CAJYcdTuXeLPB5TBaqKXn-Uj4M16F0nJLxR_LdjVG-v0tqxsm+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <http://www.facebook.com/Replicon.inc> |
twitter<http://twitter.com/Replicon>
| blog <http://www.replicon.com/blog/> | contact
us<http://www.replicon.com/about_replicon/contact_us.aspx>

We are hiring! | search
jobs<http://tbe.taleo.net/NA2/ats/careers/searchResults.jsp?org=REPLICON&cws=1&act=sort&sortColumn=1&__utma=1.651918544.1299001662.1299170819.1299174966.10&__utmb=1.8.10.1299174966&__utmc=1&__utmx=-&__utmz=1.1299174985.10.3.utmcsr=google%7Cutmccn=(organic)%7Cutmcmd=organic%7Cutmctr=replicon%20careers&__utmv=1.%7C3=Visitor%20Type=Prospects=1,&__utmk=40578466>
*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Johnston 2013-10-02 20:57:00 Re: partitioning system tables
Previous Message Chris Twombly 2013-10-02 17:03:24 Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename?