Re: Query Performance question

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query Performance question
Date: 2014-07-14 07:07:10
Message-ID: lpvviu$en3$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Magers, James, 14.07.2014 04:20:

> Thank you for your feedback. I am attaching the requested information.
> While I do not think the query is necessarily inefficient, I believe a sequence scan would be more efficient.

You can try

set enable_indexscan = off;
set enable_bitmapscan = off;

and then run your query.

But I would be very surprised if a seq scan (which reads through the whole table) was faster than those 4ms you have now

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Magers, James 2014-07-14 13:18:12 Re: Query Performance question
Previous Message Magers, James 2014-07-14 02:20:49 Re: Query Performance question