pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpartitioning system tables
3+ messages / 3 participants
[nested] [flat]
* partitioning system tables
@ 2013-10-02 20:14 Radovan Jablonovsky <radovan.jablonovsky@replicon.com>
2013-10-02 20:57 ` Re: partitioning system tables David Johnston <polobo@yahoo.com>
2013-10-04 07:45 ` Re: partitioning system tables Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 2 replies; 3+ messages in thread
From: Radovan Jablonovsky @ 2013-10-02 20:14 UTC (permalink / raw)
To: 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&sortC...;
*
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: partitioning system tables
2013-10-02 20:14 partitioning system tables Radovan Jablonovsky <radovan.jablonovsky@replicon.com>
@ 2013-10-02 20:57 ` David Johnston <polobo@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: David Johnston @ 2013-10-02 20:57 UTC (permalink / raw)
To: pgsql-admin
Radovan Jablonovsky wrote
> 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?
Is it possible now? No.
I guess the most possible partitioning scheme would be schema-based so each
schema's objects are created on their own partitioned catalogs and the
name-based search mechanism would append a where clause to the search limit
the schemas that are search based upon the current search_path. Since the
catalogs are cluster shared having a partition be database-schema name based
would be even more appropriate.
Note I'm not even sure if catalog access in this way is done via SQL or by
some other mechanism that would not be readily partitioned.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/partitioning-system-tables-tp5773152p5773155.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: partitioning system tables
2013-10-02 20:14 partitioning system tables Radovan Jablonovsky <radovan.jablonovsky@replicon.com>
@ 2013-10-04 07:45 ` Albe Laurenz <laurenz.albe@wien.gv.at>
1 sibling, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2013-10-04 07:45 UTC (permalink / raw)
To: Radovan Jablonovsky *EXTERN* <radovan.jablonovsky@replicon.com>; 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-10-04 07:45 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-10-02 20:14 partitioning system tables Radovan Jablonovsky <radovan.jablonovsky@replicon.com>
2013-10-02 20:57 ` David Johnston <polobo@yahoo.com>
2013-10-04 07:45 ` Albe Laurenz <laurenz.albe@wien.gv.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox