X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5F07C9FA65C for ; Wed, 16 Aug 2006 11:51:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 46638-03 for ; Wed, 16 Aug 2006 11:51:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from globalrelay.com (mail1.globalrelay.com [216.18.71.77]) by postgresql.org (Postfix) with ESMTP id 9191D9FA7BA for ; Wed, 16 Aug 2006 11:51:12 -0300 (ADT) X-Virus-Scanned: Scanned by GRC-AntiVirus Gateway X-GR-Acctd: YES Received: from [67.90.96.2] (HELO DaveEMachine) by globalrelay.com (CommuniGate Pro SMTP 4.2.3) with ESMTP id 100745039; Wed, 16 Aug 2006 07:51:10 -0700 From: "Dave Dutcher" To: "'Luiz K. Matsumura'" Cc: Subject: Re: Big diference in response time (query plan question) Date: Wed, 16 Aug 2006 09:51:09 -0500 Message-ID: <00ab01c6c143$69499f40$8300a8c0@tridecap.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Importance: Normal In-Reply-To: <44E32AA5.5090901@planit.com.br> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/266 X-Sequence-Number: 20451 > -----Original Message----- > From: pgsql-performance-owner@postgresql.org=20 > [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of=20 > Luiz K. Matsumura >=20 >=20 > Where I can see the current random_page_cost value ? There=20 > are some hint=20 > about what value I must set ? > Thanks in advance. > Luiz On Linux the random_page_cost is set in the postgresql.conf file. You = can see what it is set to by typing "show random_page_cost". This page has = some guidelines on random_page_cost and other server settings: http://www.powerpostgresql.com/PerfList/ As it says on the page, make sure you test a variety of queries.