Re: Query Performance question

From: "Magers, James" <James(dot)Magers(at)turner(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Query Performance question
Date: 2014-07-14 14:00:42
Message-ID: 1bd268ebd99945d6b16d12cca39893c8@CO2PR07MB601.namprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thomas,

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

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

Thank you,
James

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2014-07-14 14:48:05 Re: Query Performance question
Previous Message Thomas Kellerer 2014-07-14 13:48:03 Re: Query Performance question