Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #406
| Path | csiph.com!usenet.pasdenom.info!news.albasani.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail |
|---|---|
| From | Robert Klemme <shortcutter@googlemail.com> |
| Newsgroups | comp.databases.postgresql |
| Subject | Re: index on a partitioned table |
| Date | Fri, 17 Aug 2012 11:11:18 +0200 |
| Lines | 23 |
| Message-ID | <a96g5rFtufU1@mid.individual.net> (permalink) |
| References | <k0jbq5$n53$2@dont-email.me> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=ISO-8859-1; format=flowed |
| Content-Transfer-Encoding | 7bit |
| X-Trace | individual.net 77d7Qpjm5xSoXfUl5gd2OAOA6d+kUrvx8O/BMoBuy7ANXmZtBxqd+XcJXnSptc318= |
| Cancel-Lock | sha1:HjLzP4UFOV6erTHF0qVPa36tS0A= |
| User-Agent | Mozilla/5.0 (Windows NT 6.0; WOW64; rv:14.0) Gecko/20120713 Thunderbird/14.0 |
| In-Reply-To | <k0jbq5$n53$2@dont-email.me> |
| Xref | csiph.com comp.databases.postgresql:406 |
Show key headers only | 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
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