Postgres Pro
Downloads
Home   >   mailing lists

Re: Constraint exclusion in views - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Constraint exclusion in views
Date
Msg-id 50957270.80300@agliodbs.com
Whole thread Raw
In response to Constraint exclusion in views  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Constraint exclusion in views
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: "Gunnar \"Nick\" Bluth"
Date:
Subject: Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Next
From: Tom Lane
Date:
Subject: Re: Constraint exclusion in views