Skip site navigation (1) Skip section navigation (2)

Re: Emulating partitioning in postgresql 8.0?

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 (view raw or flat)
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)



In response to

pgsql-novice by date

Next:From: Jim C. NasbyDate: 2007-05-07 14:52:42
Subject: Re: how to view the content of schema pg_catalog?
Previous:From: Jim NasbyDate: 2007-05-06 15:23:24
Subject: Re: including limited lines depending on input parameter

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group