| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | Fei Liu <fei(dot)liu(at)aepnetworks(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Emulating partitioning in postgresql 8.0? |
| Date: | 2007-05-06 15:25:39 |
| Message-ID: | E14C4B2A-1C06-478E-BAD2-BB3B660289FF@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Apr 30, 2007, at 4:33 PM, Fei Liu wrote:
> Hi Group, I just realized that partitioning is not available in
> 8.0. As far as I can see it's only 'set constraint_exclusion = on;'
> missing from 8.0 compared with 8.1. Is there a way to emulate
> partitioning in 8.0 and achieve good performance on query with
> large amount of data?
Sure, just set it up and ensure that you have the partitioning key
indexed in every partition. Query execution won't be as fast since
the database will need to hit all those indexes, but as long as you
don't have too many partitions it shouldn't make a huge difference.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2007-05-07 14:52:42 | Re: how to view the content of schema pg_catalog? |
| Previous Message | Jim Nasby | 2007-05-06 15:23:24 | Re: including limited lines depending on input parameter |