Re: sequence scan on PK

From: Matteo Beccati <php(at)beccati(dot)com>
To: Jeroen van Iddekinge <iddekingej(at)lycos(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: sequence scan on PK
Date: 2005-05-08 17:05:11
Message-ID: 427E46C7.1080208@beccati.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Best regards
--
Matteo Beccati
http://phpadsnew.com/
http://phppgads.com/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2005-05-08 17:12:32 Re: COPY vs INSERT
Previous Message Tom Lane 2005-05-08 16:49:19 Re: sequence scan on PK