Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #852
| Path | csiph.com!weretis.net!feeder6.news.weretis.net!feeder5.news.weretis.net!news.solani.org!.POSTED!not-for-mail |
|---|---|
| From | Mladen Gogala <gogala.mladen@gmail.com> |
| Newsgroups | comp.databases.postgresql |
| Subject | Partition pruning in pg11 |
| Date | Sun, 17 Mar 2019 03:15:28 +0000 (UTC) |
| Organization | solani.org |
| Lines | 19 |
| Message-ID | <q6ke4g$gf7$1@solani.org> (permalink) |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=UTF-8 |
| Content-Transfer-Encoding | 8bit |
| X-Trace | solani.org 1552792528 16871 127.0.0.43 (17 Mar 2019 03:15:28 GMT) |
| X-Complaints-To | abuse@news.solani.org |
| NNTP-Posting-Date | Sun, 17 Mar 2019 03:15:28 +0000 (UTC) |
| User-Agent | Pan/0.145 (Duplicitous mercenary valetism; d7e168a git.gnome.org/pan2) |
| X-User-ID | eJwNyckBwCAIBMCWQNiNloMc/Zdg5jswKvNzgo7BtJ6TjFXJknTX9hY0LXoVx2gXf8wGECP5ACaCEYo= |
| Cancel-Lock | sha1:MYLbDyrojRTRGHvT2mLvBaqTg+I= |
| Xref | csiph.com comp.databases.postgresql:852 |
Show key headers only | View raw
Unfortunately, I don't have enough data to test, but I am interested whether version 11 has partition pruning? Partition pruning is an optimizer procedure which determines which partitions are needed during the parsing phase and restricts the optimization to the needed partitions only? My second question, which will probably not be answered, is whether there are any plans for global indexes? In other words, will it ever be possible to impose a primary key on a partitioned table? Currently, that is not possible: https://www.postgresql.org/docs/current/ddl-partitioning.html -- Mladen Gogala Database Consultant http://mgogala.byethost5.com
Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar
Partition pruning in pg11 Mladen Gogala <gogala.mladen@gmail.com> - 2019-03-17 03:15 +0000
Re: Partition pruning in pg11 Dimitri Fontaine <dim@tapoueh.org> - 2019-03-17 17:50 +0100
Re: Partition pruning in pg11 Mladen Gogala <gogala.mladen@gmail.com> - 2019-03-20 02:07 +0000
Re: Partition pruning in pg11 Laurenz Albe <laurenz@nospam.pn> - 2019-03-20 05:27 +0000
Re: Partition pruning in pg11 Mladen Gogala <gogala.mladen@gmail.com> - 2019-03-20 10:19 +0000
csiph-web