Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TW7Tb-0004n6-RG for pgsql-performance@postgresql.org; Wed, 07 Nov 2012 15:23:35 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TW7TZ-0001Dp-G0 for pgsql-performance@postgresql.org; Wed, 07 Nov 2012 15:23:35 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1TW7TY-0004Dl-8r for pgsql-performance@postgresql.org; Wed, 07 Nov 2012 07:23:32 -0800 Date: Wed, 7 Nov 2012 07:23:32 -0800 (PST) From: aasat To: pgsql-performance@postgresql.org Message-ID: <1352301811891-5731021.post@n5.nabble.com> In-Reply-To: <509A4917.2080303@gmail.com> References: <509944DE.6020400@gmail.com> <5099525B.5070909@gmail.com> <50995D7C.9020108@gmail.com> <509A4917.2080303@gmail.com> Subject: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.8 (/) X-Archive-Number: 201211/124 X-Sequence-Number: 48490 Please try LIMIT 1 in exists exists(select id from condition_document_excerpt where condition_id=c1686.id LIMIT 1) as v1686_has_reference -- View this message in context: http://postgresql.1045698.n5.nabble.com/Query-completed-in-1s-in-PG-9-1-and-700s-in-PG-9-2-tp5730899p5731021.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.