From: Tom Lane <tgl@sss.pgh.pa.us>
To: Connors, Bill <BConnors@rochgrp.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Questions on plan with INSERT/SELECT on partitioned table
Date: Fri, 12 Feb 2010 13:20:29 -0500
Message-ID: <18686.1265998829@sss.pgh.pa.us> (raw)
In-Reply-To: <6848376EF3611E42B309F0A3D7934BC005C8B0E4@trgmail.rochgrp.com>
References: <6848376EF3611E42B309F0A3D7934BC005C8B0E4@trgmail.rochgrp.com>
"Connors, Bill" <BConnors@rochgrp.com> writes:
> ... in my actual system where we have a couple hundred partitions this
> query takes minutes to plan.
Please note what the documentation says under "Partitioning Caveats".
The current partitioning support is not meant to scale past a few dozen
partitions. So the solution to your problem is to not have so many
partitions.
There are plans to make some fundamental changes in partitioning
support, and one of the main reasons for that is to allow it to scale to
larger numbers of partitions. This is just in the arm-waving stage
though ...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, BConnors@rochgrp.com
Subject: Re: Questions on plan with INSERT/SELECT on partitioned table
In-Reply-To: <18686.1265998829@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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