Skip site navigation (1)
Skip section navigation (2)
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?
Peripheral Links
Header And Logo
|
Site Navigation
Emulating partitioning in postgresql 8.0?
- From: Fei Liu <fei(dot)liu(at)aepnetworks(dot)com>
- To: pgsql-novice(at)postgresql(dot)org
- Subject: Emulating partitioning in postgresql 8.0?
- Date: Mon, 30 Apr 2007 17:33:41 -0400
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?
Thanks,
- Prev by Date: Re: call stored function from ecpg w/cursor
- Next by Date: Installation problem (Windows)
- Previous by thread: table design
- Next by thread: Installation problem (Windows)
- Indexes: