Re: What needs to be done for real Partitioning? - Mailing list pgsql-performance

From Tom Lane
Subject Re: What needs to be done for real Partitioning?
Date
Msg-id 3404.1111277153@sss.pgh.pa.us
Whole thread Raw
In response to Re: What needs to be done for real Partitioning?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: What needs to be done for real Partitioning?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: What needs to be done for real Partitioning?  ("Jim C. Nasby" <decibel@decibel.org>)
List 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: What needs to be done for real Partitioning?
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: What needs to be done for real Partitioning?