Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #406

Re: index on a partitioned table

Show all headers | View raw

On 16.08.2012 19:48, Greg Hennessy wrote:
> 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.

To me this seems pretty clear: indexes are not automatically inherited 
and the master table is usually empty => index child tables.  It's all 
in the docs:

http://www.postgresql.org/docs/8.1/static/ddl-inherit.html#DDL-INHERIT-CAVEATS
http://www.postgresql.org/docs/8.1/static/ddl-partitioning.html

Cheers

	robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Back to comp.databases.postgresql | Previous | Next — Previous in thread | 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