Re: What needs to be done for real Partitioning?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: PFC <lists(at)boutiquenumerique(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: What needs to be done for real Partitioning?
Date: 2005-03-20 00:05:53
Message-ID: 3404.1111277153@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2005-03-20 00:16:23 Re: What needs to be done for real Partitioning?
Previous Message Tom Lane 2005-03-20 00:03:19 Re: What needs to be done for real Partitioning?