Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TUjX7-0000zO-Jh for pgsql-performance@postgresql.org; Sat, 03 Nov 2012 19:37:29 +0000 Received: from smtp.01.com ([199.36.142.181]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TUjX1-0000oH-Gm for pgsql-performance@postgresql.org; Sat, 03 Nov 2012 19:37:29 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id A0AC63900C8 for ; Sat, 3 Nov 2012 14:37:21 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-2.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-2.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23m7DhJUPnSG for ; Sat, 3 Nov 2012 14:37:21 -0500 (CDT) Received: from smtp.01.com (localhost.localdomain [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id 7AE4E3900CC for ; Sat, 3 Nov 2012 14:37:21 -0500 (CDT) Received: from Sidney-Stratton.local (50-0-92-178.dsl.dynamic.sonic.net [50.0.92.178]) by smtp-out-2.01.com (Postfix) with ESMTPSA id 3228C3900C8 for ; Sat, 3 Nov 2012 14:37:20 -0500 (CDT) Message-ID: <50957270.80300@agliodbs.com> Date: Sat, 03 Nov 2012 12:37:20 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:16.0) Gecko/20121026 Thunderbird/16.0.2 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Constraint exclusion in views References: In-Reply-To: X-Enigmail-Version: 1.4.5 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201211/17 X-Sequence-Number: 48383 > 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