Re: Constraint exclusion in views

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Constraint exclusion in views
Date: 2012-11-03 19:37:20
Message-ID: 50957270.80300@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> Funny thing is, if I set constraint_exclusion=on, it works as
> expected. But not with constraint_exclusion=partition.

The difference between "on" and "partition" is how it treats UNION.
This seems to be working as designed.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2012-11-03 21:23:47 Re: Constraint exclusion in views
Previous Message Petr Praus 2012-11-03 17:19:06 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries