Re: Need to increase performance of a query

From: Jochen Erwied <jochen(at)pgsql-performance(dot)erwied(dot)eu>
To: Anne Rosset <arosset(at)collab(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Need to increase performance of a query
Date: 2010-06-10 19:39:24
Message-ID: 10510424234.20100610213924@erwied.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thursday, June 10, 2010, 9:34:07 PM you wrote:

> Time: 1.516 ms

> Time: 13.177 ms

I'd suppose the first query to scan a lot less rows than the second one.
Could you supply an explained plan for the fast query?

--
Jochen Erwied | home: jochen(at)erwied(dot)eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: joe(at)mbs-software(dot)de +49-2151-7294-24, FAX: -50
D-45470 Muelheim | mobile: jochen(dot)erwied(at)vodafone(dot)de +49-173-5404164

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Anne Rosset 2010-06-10 19:42:21 Re: Need to increase performance of a query
Previous Message Kenneth Marshall 2010-06-10 19:37:12 Re: Need to increase performance of a query