Home > mailing lists

partitioning system tables - Mailing list pgsql-admin

From	Radovan Jablonovsky
Subject	partitioning system tables
Date	October 2, 2013 23:15:37
Msg-id	CAJYcdTuXeLPB5TBaqKXn-Uj4M16F0nJLxR_LdjVG-v0tqxsm+A@mail.gmail.com Whole thread Raw
Responses	Re: partitioning system tables Re: partitioning system tables
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

We are hiring! | search jobs

pgsql-admin by date:

From: Chris Twombly
Date: 02 October 2013, 20:03:45
Subject: Re: DB link from postgres to Oracle; how to query Dbname.tablename?

From: David Johnston
Date: 02 October 2013, 23:57:11
Subject: Re: partitioning system tables

partitioning system tables - Mailing list pgsql-admin

Previous

Next