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 057B852A86 for ; Sun, 8 May 2005 13:19:00 -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 97976-03 for ; Sun, 8 May 2005 16:18:50 +0000 (GMT) Received: from mail1.fluidhosting.com (mail1.fluidhosting.com [66.150.201.101]) by svr1.postgresql.org (Postfix) with SMTP id A3F9A53986 for ; Sun, 8 May 2005 13:18:48 -0300 (ADT) Received: (qmail 62836 invoked by uid 399); 8 May 2005 16:18:47 -0000 Received: from unknown (HELO ?127.0.0.1?) (81.174.8.196) by mail1.fluidhosting.com with SMTP; 8 May 2005 16:18:47 -0000 Message-ID: <427E3BE6.5040702@beccati.com> Date: Sun, 08 May 2005 18:18:46 +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> In-Reply-To: <427E5130.7020702@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/78 X-Sequence-Number: 12242 Hi, > 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? You should lower random_page_cost to make the planner choose an index scan vs sequential scan. Best regards -- Matteo Beccati http://phpadsnew.com/ http://phppgads.com/