Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2

From: aasat <satriani(at)veranet(dot)pl>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2
Date: 2012-11-07 15:23:32
Message-ID: 1352301811891-5731021.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message François Beausoleil 2012-11-07 15:34:21 Re: Unique values across a table of arrays - documents and tags
Previous Message Ivan Voras 2012-11-07 15:21:47 Unique values across a table of arrays - documents and tags