Quick Links

Re: sequence scan on PK

From:	Jeroen van Iddekinge <iddekingej(at)lycos(dot)com>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	Re: sequence scan on PK
Date:	2005-05-08 18:32:14
Message-ID:	427E5B2E.7020001@lycos.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

>
> 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

In response to

Re: sequence scan on PK at 2005-05-08 16:18:46 from Matteo Beccati

Responses

Re: sequence scan on PK at 2005-05-08 17:05:11 from Matteo Beccati

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Jeroen van Iddekinge	2005-05-08 20:15:38	Re: sequence scan on PK
Previous Message	Jeroen van Iddekinge	2005-05-08 17:49:36	Re: sequence scan on PK