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 7541353A13 for ; Sun, 8 May 2005 13:32:01 -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 99813-01 for ; Sun, 8 May 2005 16:31:59 +0000 (GMT) Received: from smtp1.versatel.nl (smtp1.versatel.nl [62.58.50.88]) by svr1.postgresql.org (Postfix) with ESMTP id A93CD53A28 for ; Sun, 8 May 2005 13:31:57 -0300 (ADT) Received: (qmail 17134 invoked by uid 10); 8 May 2005 16:31:57 -0000 Received: (vexira-qq 17128-BFE2674D invoked from network) 08 May 2005 18:31:57 +0200 Received: from unknown (HELO [81.58.65.37]) ([81.58.65.37]) (envelope-sender ) by smtp1.versatel.nl (qmail-ldap-1.03) with SMTP for < >; 8 May 2005 16:31:57 -0000 Message-ID: <427E5B2E.7020001@lycos.com> Date: Sun, 08 May 2005 18:32:14 +0000 From: Jeroen van Iddekinge User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: 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> In-Reply-To: <427E3BE6.5040702@beccati.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiVirus: checked by Vexira MailArmor (version: 2.0.1.16; VAE: 6.30.0.2; VDF: 6.30.0.11; host: postbode01.zonnet.nl) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.327 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: * X-Archive-Number: 200505/80 X-Sequence-Number: 12244 > > You should lower random_page_cost to make the planner choose an index > scan vs sequential scan. > Yes , it was a bit to high (18) so a lowered it. It speeded up some pages for about 5%. Reg. Jer