Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 9.0 has a bias against indexes - Mailing list pgsql-performance

From Mladen Gogala
Subject Re: Postgres 9.0 has a bias against indexes
Date
Msg-id 4D4195FE.5000506@vmsinfo.com
Whole thread Raw
In response to Re: Postgres 9.0 has a bias against indexes  (J Sisson <sisson.j@gmail.com>)
List pgsql-performance
Tree view 
On 1/27/2011 10:51 AM, J Sisson wrote:
> Also, if random_page_cost is set to default (4.0), the planner will
> tend towards sequential scans.
scott=> show random_page_cost;
  random_page_cost
------------------
  1
(1 row)

scott=> show seq_page_cost;
  seq_page_cost
---------------
  2
(1 row)


--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com

pgsql-performance by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: Postgres 9.0 has a bias against indexes
Next
From: David Wilson
Date:
Subject: Re: Postgres 9.0 has a bias against indexes