Re: select on 1milion register = 6s

From: Jan Dittmer <jdi(at)l4x(dot)org>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Bruno Rodrigues Siqueira <bruno(at)ravnus(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: select on 1milion register = 6s
Date: 2007-08-01 17:37:11
Message-ID: 46B0C4C7.7000202@l4x.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Scott Marlowe wrote:
>> random_page_cost = 1 # units are one sequential page
>> fetch
>
> Seldom if ever is it a good idea to bonk the planner on the head with
> random_page_cost=1. setting it to 1.2 ot 1.4 is low enough, but 1.4
> to 2.0 is more realistic.

Which is probably the reason why the planner thinks a seq scan is
faster than an index scan...

Jan

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2007-08-01 18:10:14 Re: Postgres configuration for 64 CPUs, 128 GB RAM...
Previous Message Alvaro Herrera 2007-08-01 16:52:48 Re: RES: Improving select peformance