| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Anton Nikiforov <anton(at)nikiforov(dot)ru> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Huge number of raws |
| Date: | 2004-03-18 17:44:40 |
| Message-ID: | 20040318174440.GA9060@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Mar 18, 2004 at 11:59:41 +0300,
Anton Nikiforov <anton(at)nikiforov(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anton Nikiforov | 2004-03-18 17:58:39 | Re: Huge number of raws |
| Previous Message | Mike Mascari | 2004-03-18 17:24:18 | Oddity with literal intervals |