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

From Alvaro Herrera
Subject Re: What needs to be done for real Partitioning?
Date
Msg-id 20050319225624.GA8467@dcc.uchile.cl
Whole thread Raw
In response to Re: What needs to be done for real Partitioning?  (PFC <lists@boutiquenumerique.com>)
Responses Re: What needs to be done for real Partitioning?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Sat, Mar 19, 2005 at 11:24:39PM +0100, PFC wrote:

>     Some ideas :
>     hidden field (like oid was) to indicate in which partition the tuple
>     is ?

I think that to make partitioning really possible we need to have
multi-relfilenode tables.

We probably also need multi-table indexes.  Implementing these would be
good for inheritance too.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
Dios hizo a Adán, pero fue Eva quien lo hizo hombre.

pgsql-performance by date:

Previous
From: "Stacy White"
Date:
Subject: Re: What needs to be done for real Partitioning?
Next
From: Tom Lane
Date:
Subject: Re: What needs to be done for real Partitioning?