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 20:15:38
Message-ID: 427E736A.4030107@lycos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Sam Vilain 2005-05-08 21:59:07 Re: Whence the Opterons?
Previous Message Jeroen van Iddekinge 2005-05-08 18:32:14 Re: sequence scan on PK