Re: Intentionally splitting data in a table across files.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nick Fankhauser" <nickf(at)ontko(dot)com>
Cc: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Intentionally splitting data in a table across files.
Date: 2001-06-06 16:33:06
Message-ID: 27503.991845186@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Nick Fankhauser" <nickf(at)ontko(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Jenks 2001-06-06 17:32:26 postmaster successfully started?
Previous Message Nick Fankhauser 2001-06-06 14:55:55 Intentionally splitting data in a table across files.