Postgres Pro
Downloads
Home   >   mailing lists

Re: Intentionally splitting data in a table across files. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Intentionally splitting data in a table across files.
Date
Msg-id 27503.991845186@sss.pgh.pa.us
Whole thread Raw
In response to Intentionally splitting data in a table across files.  ("Nick Fankhauser" <nickf@ontko.com>)
Responses Re: Intentionally splitting data in a table across files.  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Tree view 
"Nick Fankhauser" <nickf@ontko.com> writes:
> Does PostgreSQL support (or some day will support) "partitioned tables"?

It's not on anyone's radar screen AFAIK.

> Alternately, does anyone have an idea about how to address this need in a
> different way using existing tools?

Make a view that's a UNION of the component tables, plus rules that
cause inserts to go into the appropriate components.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Intentionally splitting data in a table across files.
Next
From: Dave Stokes
Date:
Subject: changes sequences to unique