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 089DC5292E for ; Thu, 9 Jun 2005 13:37:39 -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 58103-10 for ; Thu, 9 Jun 2005 16:37:31 +0000 (GMT) Received: from mail49.messagelabs.com (mail49.messagelabs.com [193.109.255.19]) by svr1.postgresql.org (Postfix) with SMTP id 3918952914 for ; Thu, 9 Jun 2005 13:37:29 -0300 (ADT) X-VirusChecked: Checked X-Env-Sender: alexs@advfn.com X-Msg-Ref: server-11.tower-49.messagelabs.com!1118335047!1987257!1 X-StarScan-Version: 5.4.15; banners=-,-,- X-Originating-IP: [212.161.99.149] Received: (qmail 5643 invoked from network); 9 Jun 2005 16:37:27 -0000 Received: from mail.advfn.com (212.161.99.149) by server-11.tower-49.messagelabs.com with SMTP; 9 Jun 2005 16:37:27 -0000 Received: from [213.86.19.101] (helo=[192.168.0.185]) by mail.advfn.com with esmtp (Exim 4.22) id 1DgQ22-0000Yq-HP for pgsql-performance@postgresql.org; Thu, 09 Jun 2005 17:37:26 +0100 Mime-Version: 1.0 (Apple Message framework v730) Content-Transfer-Encoding: 7bit Message-Id: Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-performance@postgresql.org From: Alex Stapleton Subject: random_page_cost = 1? Date: Thu, 9 Jun 2005 17:37:25 +0100 X-Mailer: Apple Mail (2.730) X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/217 X-Sequence-Number: 12854 Is this advisable? The disks are rather fast (15k iirc) but somehow I don't think they are covered in whatever magic fairy dust it would require for a sequential read to be as fast as a random one. However I could be wrong, are there any circumstances when this is actually going to help performance?