Re: Need to increase performance of a query - Mailing list pgsql-performance

From Jochen Erwied
Subject Re: Need to increase performance of a query
Date
Msg-id 10510424234.20100610213924@erwied.eu
Whole thread Raw
In response to Re: Need to increase performance of a query  (Anne Rosset <arosset@collab.net>)
Responses Re: Need to increase performance of a query  (Anne Rosset <arosset@collab.net>)
List 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@erwied.eu     +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work: joe@mbs-software.de  +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile: jochen.erwied@vodafone.de       +49-173-5404164


pgsql-performance by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: Need to increase performance of a query
Next
From: Jochen Erwied
Date:
Subject: Re: Need to increase performance of a query