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