Re: Intentionally splitting data in a table across files.

From: "Brian Baquiran" <brianb(at)edsamail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Intentionally splitting data in a table across files.
Date: 2001-06-07 04:00:17
Message-ID: 9fmufh$djv$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in message
news:27503(dot)991845186(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> "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.

Tried this in 7.1.2, but it returns ERROR: "Views on unions not
implemented."

> regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Romuald Lobet 2001-06-07 09:17:21 Re: What CASE tools and clients for Postgres?
Previous Message Brian McCane 2001-06-07 01:48:45 Re: Intentionally splitting data in a table across files. (fwd)