Re: - Mailing list pgsql-performance

From Yann Michel
Subject Re:
Date
Msg-id 20050121123008.GA13904@zoom.spline.inf.fu-berlin.de
Whole thread Raw
In response to Re:  ("Matt Casters" <Matt.Casters@advalvas.be>)
Responses Re:  ("Matt Casters" <Matt.Casters@advalvas.be>)
Re:  (Matteo Beccati <php@beccati.com>)
List pgsql-performance
Hi,

On Fri, Jan 21, 2005 at 09:50:46AM +0100, Matt Casters wrote:
>
> > Some people have been doing it using a union view. There isn't actually
> > a partition feature.
>
> Actually, there is.  If found this example on pgsql-performance:
>
> >>   CREATE TABLE super_foo ( partition NUMERIC, bar NUMERIC );
> >>   ANALYZE super_foo ;
> >>
> >>   CREATE TABLE sub_foo1 () INHERITS ( super_foo );
[...]
> >>
> >>   CREATE TABLE sub_foo2 () INHERITS ( super_foo );
[...]
> >>

Yes, this could be used instead of a view. But there is one thing
missing. You can't just insert into super_foo and aquire the "correct
partition". You will still have to insert into the correct underlying
table. "Real" partitioning will take care of correct partition
selection.

Regards,
Yann


pgsql-performance by date:

Previous
From: Bernd Heller
Date:
Subject: Re: column without pg_stats entry?!
Next
From: "Matt Casters"
Date:
Subject: Re: