X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 8ABB5924D42 for ; Thu, 29 May 2003 02:15:33 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 56287-05 for ; Thu, 29 May 2003 02:15:32 -0400 (EDT) Received: from shield.nordlb.lv (shield.pirmabanka.lv [195.114.57.4]) by developer.postgresql.org (Postfix) with ESMTP id 97A06924CCF for ; Thu, 29 May 2003 02:15:31 -0400 (EDT) Received: from wall2.pirmabanka.lv (wall2-pub.nordlb.lv [195.114.57.14]) by shield.nordlb.lv (8.12.9/8.12.9) with SMTP id h4T6FSGZ021927 for ; Thu, 29 May 2003 09:15:29 +0300 Received: from share.nordlb.lv ([10.0.0.10]) by wall2.pirmabanka.lv; Thu, 29 May 2003 09:15:27 +0300 (EET DST) Received: from pc311x1.nordlb.lv (localhost.localdomain [127.0.0.1]) by nordlb.lv (8.11.6/8.11.6) with SMTP id h4T6FQA00659 for ; Thu, 29 May 2003 09:15:27 +0300 Received: (qmail 26137 invoked by uid 100); 29 May 2003 06:18:18 -0000 Date: Thu, 29 May 2003 09:18:18 +0300 From: "Victor Yegorov" To: "Chad Thompson" Cc: "pgsql-performance" Subject: Re: >24 hour restore Message-ID: <20030529061818.GA23596@nordlb.lv> References: <027901c32530$273839c0$32021aac@chad> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline In-Reply-To: <027901c32530$273839c0$32021aac@chad> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/259 X-Sequence-Number: 2038 * Chad Thompson [28.05.2003 19:08]: > I hope this is something easy/stupid that I have missed. I know that w/ > mirroring my write times are not improved, but they are DEFINATLY not this > bad. Well, I have had something similar to your case, except for size - it's was about 1 Gb. I've dropped all foreign keys, triggers and, also, all indexes. As I've found, each index takes additional time for inserts/updates/deletes, so it's recommended to create indexes after data manipulations. If this will not help, I don't know. May be hardware problems... -- Victor Yegorov