Re: select on 1milion register = 6s - Mailing list pgsql-performance

From Jan Dittmer
Subject Re: select on 1milion register = 6s
Date
Msg-id 46B0C4C7.7000202@l4x.org
Whole thread Raw
In response to Re: select on 1milion register = 6s  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List 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

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: RES: Improving select peformance
Next
From: "Luke Lonergan"
Date:
Subject: Re: Postgres configuration for 64 CPUs, 128 GB RAM...