Skip site navigation (1) Skip section navigation (2)

Re: plan time of MASSIVE partitioning ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: PostgreSQL - Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
Cc: pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: plan time of MASSIVE partitioning ...
Date: 2010-09-03 14:40:54
Message-ID: 22483.1283524854@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
=?iso-8859-1?Q?PostgreSQL_-_Hans-J=FCrgen_Sch=F6nig?= <postgres(at)cybertec(dot)at> writes:
> imagine a system with, say, 1000 partitions (heavily indexed) or so. the time taken by the planner is already fairly heavy in this case.

As the fine manual points out, the current scheme for managing
partitioned tables isn't intended to scale past a few dozen partitions.

I think we'll be able to do better when we have an explicit
representation of partitioning, since then the planner won't
have to expend large amounts of effort reverse-engineering knowledge
about how an inheritance tree is partitioned.  Before that happens,
it's not really worth the trouble to worry about such cases.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: PostgreSQL - Hans-Jürgen SchönigDate: 2010-09-03 14:46:26
Subject: Re: plan time of MASSIVE partitioning ...
Previous:From: Tom LaneDate: 2010-09-03 14:31:29
Subject: Re: regclass without error?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group