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@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
