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)
In response to
pgsql-novice by date
|Next:||From: Jim C. Nasby||Date: 2007-05-07 14:52:42|
|Subject: Re: how to view the content of schema pg_catalog?|
|Previous:||From: Jim Nasby||Date: 2007-05-06 15:23:24|
|Subject: Re: including limited lines depending on input parameter|