Postgres Pro
Downloads
Home   >   mailing lists

Select query ignores index on large table - Mailing list pgsql-general

From Michael Kemanetzis
Subject Select query ignores index on large table
Date
Msg-id AANLkTikG=_FM+taw_XqNiS4OhMJJjpsxP-fwG_6ejf7R@mail.gmail.com
Whole thread Raw
Responses Re: Select query ignores index on large table
Re: Select query ignores index on large table
List pgsql-general
Tree view
Hello, I'm experiencing a strange behavior running a simple select query on a table that has about 12 million rows. Specifically, changing the "LIMIT" value seems to change the execution plan but the result in one of the cases is unjustifiably slow, as if it ignores all indexes.

The table structure, the queries used and the results are here: http://pastebin.com/fn36BuKs

Is there anything I can do to improve the speed of this query?

Are there any configuration settings that I should change?

Thanks,
Mike

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: Queyring for columns which are exist in table.
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Select query ignores index on large table