Groups > comp.databases.postgresql > #853

Re: Partition pruning in pg11

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From	Dimitri Fontaine <dim@tapoueh.org>
Newsgroups	comp.databases.postgresql
Subject	Re: Partition pruning in pg11
Date	Sun, 17 Mar 2019 17:50:46 +0100
Organization	A noiseless patient Spider
Lines	29
Message-ID	<m2ftrla1i1.fsf@laptop.tapoueh.org> (permalink)
References	<q6ke4g$gf7$1@solani.org>
Mime-Version	1.0
Content-Type	text/plain; charset=utf-8
Content-Transfer-Encoding	8bit
Injection-Info	reader02.eternal-september.org; posting-host="0daf8a07da3102ee6a9b95aee1945280"; logging-data="18664"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/Gu88NTiwy098Owf3zhfGd"
User-Agent	Gnus/5.13 (Gnus v5.13) Emacs/25.2 (darwin)
Cancel-Lock	sha1:bWNYkGtvbzGYuFc1YT1/lRn8qcI= sha1:rhcvgs1lu/dOohiojSPhOp8fhlw=
Xref	csiph.com comp.databases.postgresql:853

Show key headers only | View raw

Mladen Gogala <gogala.mladen@gmail.com> writes:

> 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?

Yes:

  https://blog.2ndquadrant.com/partition-elimination-postgresql-11/

Though if you don't have enough data to test, one has to wonder why the
answer is interesting for you…

> 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:

Does not seem to be on the works. Also, what would be the advantage of
such a big index? After all PostgreSQL 11 already support primary keys
spanning a partition tree.

  https://www.postgresql.org/message-id/CAMkU%3D1xg5iJcuzjpj0a4Abbup-EVQ%3D22hCCr8SfrFYO%3D8UL5qA%40mail.gmail.com

Regards,
-- 
Dimitri Fontaine

Back to comp.databases.postgresql | Previous | Next — Previous in thread | 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