Re: What needs to be done for real Partitioning?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@dcc.uchile.cl>
Cc: PFC <lists@boutiquenumerique.com>, Josh Berkus <josh@agliodbs.com>, pgsql-performance@postgresql.org
Date: 2005-03-20T00:05:53Z
Lists: pgsql-performance
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> We probably also need multi-table indexes.

As Josh says, that seems antithetical to the main point of partitioning,
which is to be able to rapidly remove (and add) partitions of a table.
If you have to do index cleaning before you can drop a partition, what's
the point of partitioning?

			regards, tom lane