Postgres Pro
Downloads
Home   >   mailing lists

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

From Matteo Beccati
Subject Re: sequence scan on PK
Date
Msg-id 427E46C7.1080208@beccati.com
Whole thread Raw
In response to Re: sequence scan on PK  (Jeroen van Iddekinge <iddekingej@lycos.com>)
Responses Re: sequence scan on PK
List pgsql-performance
Tree view 
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/

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: sequence scan on PK
Next
From: "Jim C. Nasby"
Date:
Subject: Re: COPY vs INSERT