Re: Physical Database Configuration

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Guy Rouillier" <guyr(at)masergy(dot)com>
Cc: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Physical Database Configuration
Date: 2004-03-26 18:23:45
Message-ID: 25610.1080325425@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Guy Rouillier" <guyr(at)masergy(dot)com> writes:
> Under Oracle, we use a partitioned
> tablespace for the busiest table, so that we can remove old partitions
> after an aging period. This one table is the majority of that 25 GB.

We don't have any direct support for that, but some people fake it by
using inheritance or views to make several independent tables look like
one big table. You can find discussions in the archives.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-03-26 18:24:33 Re: 7.4.2 on Solaris 9 - Error
Previous Message Guy Rouillier 2004-03-26 17:53:47 Physical Database Configuration