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 3F8F05E46CF for ; Thu, 12 Aug 2004 15:57:27 -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 04093-09 for ; Thu, 12 Aug 2004 18:57:23 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id CB1165E3AC5 for ; Thu, 12 Aug 2004 15:57:21 -0300 (ADT) Received: from wp2000 ([157.157.178.195] [157.157.178.195]) by quasar.skima.is; Thu, 12 Aug 2004 18:57:20 Z Message-Id: <001d01c4809e$7e442600$0100000a@wp2000> From: "gnari" To: References: <6EE64EF3AB31D5448D0007DD34EEB3412A7450@Herge.rcsinc.local> Subject: Re: Hardware upgrade for a high-traffic database Date: Thu, 12 Aug 2004 18:59:28 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200408/191 X-Sequence-Number: 7827 "Merlin Moncure" wrote: -- optional cluster user_message_idx messages; would one not have to repeat this operation regularly, to keep any advantage of this ? my impression was that this is a relatively heavy operation on a large table. gnari