Re: Seqscan rather than Index - Mailing list pgsql-performance

From Tom Lane
Subject Re: Seqscan rather than Index
Date
Msg-id 26003.1103218313@sss.pgh.pa.us
Whole thread Raw
In response to Seqscan rather than Index  (Jon Anderson <jonanderson.mn@gmail.com>)
List pgsql-performance
Jon Anderson <jonanderson.mn@gmail.com> writes:
> Any hints on what to do to make PostgreSQL use the index?

You might want to reduce random_page_cost a little.

Keep in mind that your test case is small enough to fit in RAM and is
probably not reflective of what will happen with larger tables.

            regards, tom lane

pgsql-performance by date:

Previous
From: John A Meinel
Date:
Subject: Re: Improve performance of query
Next
From: Adi Alurkar
Date:
Subject: UNION ALL vs INHERITANCE