index on a partitioned table - 08-16-2012 , 12:48 PM
I am using postgresql 8.1.3 on redhat, and trying to use partitioned
tables to manage a multi-terabyte table. I've created the parent table
and the child tables.
If I want to add an index, does it matter if I index the parent or the
collection of children? I can't find a discussion of the pros or cons
on this in the documentation.
Re: index on a partitioned table - 08-17-2012 , 04:11 AM
On 16.08.2012 19:48, Greg Hennessy wrote:
and the master table is usually empty => index child tables. It's all
in the docs:
remember.guy do |as, often| as.you_can - without end
Re: index on a partitioned table - 08-17-2012 , 02:31 PM
On Thu, 16 Aug 2012 17:48:53 +0000, Greg Hennessy wrote:
tables. And there are no global indexes, it isn't possible to have a
unique index across all the tables.
Re: index on a partitioned table - 08-17-2012 , 07:30 PM
On 2012-08-16, Greg Hennessy <greg.hennessy (AT) cox (DOT) net> wrote:
having it. usually this means all of them.
indexing the parent will bave no possitive effect, the database knows it's
you're going to want to turn constraint excluusion "on" if you haven't
alredy. (8.1 doesn't have a 'partition' setting for constraint exclusiin)
upgrade to someting newer like 9.1 for improved performance.
⚂⚃ 100% natural
--- Posted via news://freenews.netfront.net/ - Complaints to news (AT) netfront (DOT) net ---