Re: Seqscan rather than Index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jon Anderson <jonanderson(dot)mn(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Seqscan rather than Index
Date: 2004-12-16 17:31:53
Message-ID: 26003.1103218313@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jon Anderson <jonanderson(dot)mn(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Adi Alurkar 2004-12-16 20:06:46 UNION ALL vs INHERITANCE
Previous Message John A Meinel 2004-12-16 17:24:26 Re: Improve performance of query