Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #407
| Path | csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail |
|---|---|
| From | Mladen Gogala <gogala.mladen@gmail.com> |
| Newsgroups | comp.databases.postgresql |
| Subject | Re: index on a partitioned table |
| Date | Fri, 17 Aug 2012 19:31:23 +0000 (UTC) |
| Organization | solani.org |
| Lines | 19 |
| Message-ID | <pan.2012.08.17.19.30.50@gmail.com> (permalink) |
| References | <k0jbq5$n53$2@dont-email.me> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=UTF-8 |
| Content-Transfer-Encoding | 8bit |
| X-Trace | solani.org 1345231883 3919 eJwFwQkBwDAIA0BLDU8ocoAV/xJ250pwwug0X19cPo5wnuaZXhyEfV4dd2JFizBXoCUza/QHFR8QnA== (17 Aug 2012 19:31:23 GMT) |
| X-Complaints-To | abuse@news.solani.org |
| NNTP-Posting-Date | Fri, 17 Aug 2012 19:31:23 +0000 (UTC) |
| User-Agent | Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) |
| X-User-ID | eJwFwYkBADAEBLCVKOcZB639R2gCMbZxNZhisVIjcVq4IyIptEtc6Km3b3vec/MpUaKWkfMBDnoQrA== |
| Cancel-Lock | sha1:kW1GJtvfcPzLepJzaCRZUvuNy7I= |
| X-NNTP-Posting-Host | eJwNysERwDAIA8GasDkxKceBqP8S4n0vW6GuFEqMDc1HqCbmybMa1XV2uj2itXxrFDve5AcWVRCE |
| Xref | csiph.com comp.databases.postgresql:407 |
Show key headers only | 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
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