Re: partitioned lookup table?

On Fri, Apr 16, 2010 at 04:48:18PM +0200, Andreas Kretschmer wrote:
> Hi @all,
>
> A question, found in the german PG-Forum:
>
> is it possible to partitionate a lookup-table? What i mean is:
>
> test=# create table foo(i int primary key);
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" for table "foo"
> CREATE TABLE
> test=*# create table bla ( i int references foo);
> CREATE TABLE
> test=*# insert into foo values (1);
> INSERT 0 1
> test=*# insert into bla values (1);
> INSERT 0 1
> test=*# create table foo_2 () inherits (foo);
> CREATE TABLE
> test=*# alter table foo_2 add primary key (i);
> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "foo_2_pkey" for table "foo_2"
> ALTER TABLE

Kinda.

http://people.planetpostgresql.org/dfetter/index.php?/archives/51-Partitioning-Is-Such-Sweet-Sorrow.html

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate