Re: What needs to be done for real Partitioning?

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: PFC <lists(at)boutiquenumerique(dot)com>
Cc: 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-19 22:56:24
Message-ID: 20050319225624.GA8467@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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[(at)]dcc(dot)uchile(dot)cl>)
Dios hizo a Adán, pero fue Eva quien lo hizo hombre.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-03-19 23:02:39 Re: What needs to be done for real Partitioning?
Previous Message Stacy White 2005-03-19 22:54:20 Re: What needs to be done for real Partitioning?