Re: Huge number of raws - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Huge number of raws
Date
Msg-id 20040318174440.GA9060@wolff.to
Whole thread Raw
In response to Re: Huge number of raws  (Anton Nikiforov <anton@nikiforov.ru>)
Responses Re: Huge number of raws
List pgsql-general
On Thu, Mar 18, 2004 at 11:59:41 +0300,
  Anton Nikiforov <anton@nikiforov.ru> wrote:
> And one more question - is there in postgress something like table
> partitioning in Oracle to store data according to the some rules, like a
> group of data source (IP network or something)?

There isn't currently a partitioning tool. Some table space features
are being developed for 7.5.

Depending on what you really are trying to accomplish there are some
things you can do now. Partial indexes get be used to speed up index
searches over a subset of rows in a table. You can also use sym links
to move tables on to different file systems, but you need to be careful
when doing this.

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Oddity with literal intervals
Next
From: Anton Nikiforov
Date:
Subject: Re: Huge number of raws