X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AE2FA53A02 for ; Sun, 8 May 2005 14:05:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04281-06 for ; Sun, 8 May 2005 17:05:16 +0000 (GMT) Received: from mail1.fluidhosting.com (mail1.fluidhosting.com [66.150.201.101]) by svr1.postgresql.org (Postfix) with SMTP id 943DF533A5 for ; Sun, 8 May 2005 14:05:14 -0300 (ADT) Received: (qmail 47441 invoked by uid 399); 8 May 2005 17:05:12 -0000 Received: from unknown (HELO ?127.0.0.1?) (81.174.8.196) by mail1.fluidhosting.com with SMTP; 8 May 2005 17:05:12 -0000 Message-ID: <427E46C7.1080208@beccati.com> Date: Sun, 08 May 2005 19:05:11 +0200 From: Matteo Beccati User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jeroen van Iddekinge Cc: pgsql-performance@postgresql.org Subject: Re: sequence scan on PK References: <427E2941.9070105@lycos.com> <427E17BC.7050407@arbash-meinel.com> <427E5130.7020702@lycos.com> <427E3BE6.5040702@beccati.com> <427E5B2E.7020001@lycos.com> In-Reply-To: <427E5B2E.7020001@lycos.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/82 X-Sequence-Number: 12246 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/