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

Groups > comp.databases.postgresql > #407

Re: index on a partitioned table

Show all headers | View raw

On Thu, 16 Aug 2012 17:48:53 +0000, 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.

In Postgres, parent table is usually empty. You can only index child 
tables. And there are no global indexes, it isn't possible to have a 
unique index across all the tables.



-- 
Mladen Gogala
http://mgogala.freehostia.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