Re: Query Performance question - Mailing list pgsql-performance

From Magers, James
Subject Re: Query Performance question
Date
Msg-id 1bd268ebd99945d6b16d12cca39893c8@CO2PR07MB601.namprd07.prod.outlook.com
Whole thread Raw
In response to Re: Query Performance question  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Query Performance question
List pgsql-performance
Thomas,

I would have to agree that the current results do indicate that.  However, I have run this explain analyze multiple
timesand the timing varies from about 4ms to 35ms using the Bitmap Heap Scan.  Here is an explain plan from Thursday of
lastweek that shows about 21ms.  Part of the issue in trying to isolate if the query can be faster is that once the
datais cached any way that the query is executed appears to be quicker.
 

http://explain.depesz.com/s/SIX1

Thank you,
James

pgsql-performance by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Query Performance question
Next
From: "Tomas Vondra"
Date:
Subject: Re: Query Performance question