Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 013521337B54 for ; Mon, 18 Apr 2011 04:39:32 -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 71754-02 for ; Mon, 18 Apr 2011 07:38:19 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f46.google.com (mail-ew0-f46.google.com [209.85.215.46]) by mail.postgresql.org (Postfix) with ESMTP id 294911337B49 for ; Mon, 18 Apr 2011 04:38:10 -0300 (ADT) Received: by ewy4 with SMTP id 4so1271234ewy.19 for ; Mon, 18 Apr 2011 00:38:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=JzF/EGRr/UMSdTBW33Cug6z88Uz5U9fyRVPOw/f+5/0=; b=yDp6hQO1BTA0/89XA//2NCnT1Ejin+vv9iqnV/RRBuMuKqO2YvsDBQxa9w0Axh02RZ 82yQfjJRnNBT5LTelqpkKSWRHyJklvOhNKgRfq4I1cfQLTjXW1ndG8LvrUZln7nIqZSB 0Vk0TPqDC1braqppHCl6bRrxCEJUeEHVRDr84= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=wK6Mx1uirRwpjaJBGAL3If7s05q1Yk9ioez/6mwoEWSMxpjqPXDSonQ6OK3AlTO6Qh tgEpdI2uj0pCSnMuZyB7E6GzRWNc28ngsxRy7/CZ2hatLikKTQdNfCClr+b8XuOfa7qT aXnAGFOBo5QaeQCir0eiBAQyUYFw0xCiPidAk= MIME-Version: 1.0 Received: by 10.213.106.196 with SMTP id y4mr2023517ebo.29.1303112290052; Mon, 18 Apr 2011 00:38:10 -0700 (PDT) Received: by 10.213.25.139 with HTTP; Mon, 18 Apr 2011 00:38:10 -0700 (PDT) In-Reply-To: References: Date: Mon, 18 Apr 2011 01:38:10 -0600 Message-ID: Subject: Re: REINDEX takes half a day (and still not complete!) From: Scott Marlowe To: Phoenix Kiula Cc: Merlin Moncure , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.897 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, NORMAL_HTTP_TO_IP=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201104/242 X-Sequence-Number: 43304 On Sun, Apr 17, 2011 at 11:19 PM, Phoenix Kiula wrote: > Btw, hardware is not an issue. My db has been working fine for a > while. Smaller poorer systems around the web run InnoDB databases. I > wouldn't touch that with a barge pole. > > I have a hardware RAID controller, not "fake". It's a good quality > battery-backed 3Ware: > http://192.19.193.26/products/serial_ata2-9000.asp (please stop top posting) Also, when you run top and hit c what do those various postgres processes say they're doing? bgwriter, SELECT, VACUMM etc?