Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id EC9371337999 for ; Sun, 17 Apr 2011 15:14:15 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 44891-02 for ; Sun, 17 Apr 2011 18:13:58 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from zeus.simkin.ca (zeus.simkin.ca [72.51.27.124]) by mail.postgresql.org (Postfix) with ESMTP id D55FD13364DE for ; Sun, 17 Apr 2011 15:13:57 -0300 (ADT) Received: from charon.medialogik.com (S0106000c6eb33e73.vc.shawcable.net [96.49.227.24]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by zeus.simkin.ca (Postfix) with ESMTPSA id BE1F927018E for ; Sun, 17 Apr 2011 11:13:55 -0700 (PDT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: REINDEX takes half a day (and still not complete!) Date: Sun, 17 Apr 2011 11:13:52 -0700 User-Agent: KMail/1.13.5 (Linux/2.6.35-25-generic; KDE/4.5.1; i686; ; ) References: In-Reply-To: X-KMail-Markup: true MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="Boundary-01=_g3yqNr4Njph3Ibx" Content-Transfer-Encoding: 7bit Message-Id: <201104171113.52597@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/233 X-Sequence-Number: 43295 --Boundary-01=_g3yqNr4Njph3Ibx Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit On April 17, 2011, Phoenix wrote: > >> Surely this is not tenable for enterprise environments? I am on a > >> 64bit RedHat server with dual CPU Intel Woodcrest or whatever that was > >> called. Postgres is 8.2.9. > >> .. and you have essentially 1 disk drive. Your hardware is not sized for a database server. >> it's a RAID 1 setup. Two Raptor 10000rpm disks. --Boundary-01=_g3yqNr4Njph3Ibx Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit

On April 17, 2011, Phoenix <phoenix.kiula@gmail.com> wrote:

> >> Surely this is not tenable for enterprise environments? I am on a

> >> 64bit RedHat server with dual CPU Intel Woodcrest or whatever that was

> >> called. Postgres is 8.2.9.

> >>

.. and you have essentially 1 disk drive. Your hardware is not sized for a database server.

>> it's a RAID 1 setup. Two Raptor 10000rpm disks.

--Boundary-01=_g3yqNr4Njph3Ibx--