Re: Physical Database Configuration - Mailing list pgsql-general

From Tom Lane
Subject Re: Physical Database Configuration
Date
Msg-id 25610.1080325425@sss.pgh.pa.us
Whole thread Raw
In response to Physical Database Configuration  ("Guy Rouillier" <guyr@masergy.com>)
List pgsql-general
"Guy Rouillier" <guyr@masergy.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

pgsql-general by date:

Previous
From: "Pablo Montilla"
Date:
Subject: Waiting for Commit
Next
From: Eric Ridge
Date:
Subject: pg 7.3, cursors, and prepared queries