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 00FE452A38 for ; Sun, 8 May 2005 12:49:32 -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 94545-06 for ; Sun, 8 May 2005 15:49:23 +0000 (GMT) Received: from smtp1.versatel.nl (smtp1.versatel.nl [62.58.50.88]) by svr1.postgresql.org (Postfix) with ESMTP id EECAA52A2F for ; Sun, 8 May 2005 12:49:21 -0300 (ADT) Received: (qmail 10383 invoked by uid 10); 8 May 2005 15:49:19 -0000 Received: (vexira-qq 10376-26CE7BED invoked from network) 08 May 2005 17:49:19 +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 15:49:19 -0000 Message-ID: <427E5130.7020702@lycos.com> Date: Sun, 08 May 2005 17:49:36 +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> In-Reply-To: <427E17BC.7050407@arbash-meinel.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.309 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: * X-Archive-Number: 200505/77 X-Sequence-Number: 12241 > > You could tweak with several settings to get it to do an index scan > earlier, but these would probably break other queries. You don't need to > tune for 100 rows, morelike 100k or 100M. Thanks for respone. The index scan was a little bit faster for id=1 and faster for id=99. Which settings shoud I change for this? cpu_index_tuple_cost , cpu_operator_cost, cpu_tuple_cost? Jer.