Groups > comp.databases.postgresql > #852

Partition pruning in pg11

From	Mladen Gogala <gogala.mladen@gmail.com>
Newsgroups	comp.databases.postgresql
Subject	Partition pruning in pg11
Date	2019-03-17 03:15 +0000
Organization	solani.org
Message-ID	<q6ke4g$gf7$1@solani.org> (permalink)

Show all headers | 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

Thread

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