Postgres Pro
Downloads
Home   >   mailing lists

partitioning system tables - Mailing list pgsql-admin

From Radovan Jablonovsky
Subject partitioning system tables
Date
Msg-id CAJYcdTuXeLPB5TBaqKXn-Uj4M16F0nJLxR_LdjVG-v0tqxsm+A@mail.gmail.com
Whole thread Raw
Responses Re: partitioning system tables  (David Johnston <polobo@yahoo.com>)
Re: partitioning system tables  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Chris Twombly
Date:
Subject: Re: DB link from postgres to Oracle; how to query Dbname.tablename?
Next
From: David Johnston
Date:
Subject: Re: partitioning system tables