X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5F580474E42 for ; Wed, 26 Feb 2003 07:00:48 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 52668-02 for ; Wed, 26 Feb 2003 07:00:37 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 79AE14758DC for ; Wed, 26 Feb 2003 07:00:37 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18o0Eq-0002UV-00 for ; Wed, 26 Feb 2003 07:00:40 -0500 Date: Wed, 26 Feb 2003 07:00:40 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Index File growing big. Message-ID: <20030226070040.C8814@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from pragati@phildigital.com on Wed, Feb 26, 2003 at 11:56:48AM +0530 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/208 X-Sequence-Number: 1264 On Wed, Feb 26, 2003 at 11:56:48AM +0530, PRAGATI SAVAIKAR wrote: > > Can U please suggest some way to avoid the file getting created when we > move the data file (along with the index files) to another partition. Yes. Submit a patch which implements tablespaces ;-) Seriously, there is no way to avoid this in the case where you are moving the files by hand. The suggestions for how to move files around note this. If this is merely a disk-size problem, why not move the entire postgres installation to another disk, and make a link to it. If you still need to spread things across disks, you can move things which don't change in size very much. A good candidate here is the WAL (pg_xlog), since it grows to a predictable size. You even get a performance benefit. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110