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

From Jeroen van Iddekinge
Subject Re: sequence scan on PK
Date
Msg-id 427E736A.4030107@lycos.com
Whole thread Raw
In response to Re: sequence scan on PK  (Matteo Beccati <php@beccati.com>)
List pgsql-performance
Matteo Beccati wrote:

> Hi,
>
>> Yes , it was a bit to high (18) so a lowered it. It speeded up some
>> pages for about 5%.
>
>
> 18? The default is 4 if I can remember correctly. I wonder if your db
> has ever seen an index scan ;)
>

I was expermenting how much some setting influence has on the perfomance
of some web application.
So I think i forgot to change the setting back and got some strange
query plans.

Thanks
Jer


pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: COPY vs INSERT
Next
From: Sam Vilain
Date:
Subject: Re: Whence the Opterons?