Groups > comp.databases.postgresql > #405

index on a partitioned table

From	Greg Hennessy <greg.hennessy@cox.net>
Newsgroups	comp.databases.postgresql
Subject	index on a partitioned table
Date	2012-08-16 17:48 +0000
Organization	A noiseless patient Spider
Message-ID	<k0jbq5$n53$2@dont-email.me> (permalink)

Show all headers | View raw

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.

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

index on a partitioned table Greg Hennessy <greg.hennessy@cox.net> - 2012-08-16 17:48 +0000
  Re: index on a partitioned table Robert Klemme <shortcutter@googlemail.com> - 2012-08-17 11:11 +0200
  Re: index on a partitioned table Mladen Gogala <gogala.mladen@gmail.com> - 2012-08-17 19:31 +0000
  Re: index on a partitioned table Jasen Betts <jasen@xnet.co.nz> - 2012-08-18 00:30 +0000

csiph-web