Postgres Pro
Downloads
Home   >   mailing lists

Re: sequence scan on PK - Mailing list pgsql-performance

From Jeroen van Iddekinge
Subject Re: sequence scan on PK
Date
Msg-id 427E5B2E.7020001@lycos.com
Whole thread Raw
In response to Re: sequence scan on PK  (Matteo Beccati <php@beccati.com>)
Responses Re: sequence scan on PK  (Matteo Beccati <php@beccati.com>)
List pgsql-performance
Tree view 
>
> You should lower random_page_cost to make the planner choose an index
> scan vs sequential scan.
>
Yes , it was a bit to high (18) so a lowered it. It speeded up some
pages for about 5%.

Reg. Jer

pgsql-performance by date:

Previous
From: John A Meinel
Date:
Subject: Re: sequence scan on PK
Next
From: Tom Lane
Date:
Subject: Re: sequence scan on PK