X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0C90B474E4F for ; Wed, 26 Feb 2003 02:29:30 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 92308-03 for ; Wed, 26 Feb 2003 02:29:19 -0500 (EST) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 54BE5474E42 for ; Wed, 26 Feb 2003 02:29:14 -0500 (EST) Received: (qmail 8379 invoked from network); 26 Feb 2003 07:27:38 -0000 Received: from unknown (HELO system67.trade-india-local.com) (192.168.0.67) by infocom-236-129-del.trade-india.com with SMTP; 26 Feb 2003 07:27:38 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: PRAGATI SAVAIKAR , Subject: Re: Index File growing big. Date: Wed, 26 Feb 2003 12:59:23 +0530 User-Agent: KMail/1.5 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200302261259.23604.mallah@trade-india.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/207 X-Sequence-Number: 1263 I remember this is your second posting for the same problem. I hope you are aware that postgres can manage multiple databases that lie in different partitions. If its feasible for you you may think of moving the *big* tables in another database which can be initialised in another partition. it depends on ur app design as you will have to create a new db connection. another possibility is to buy a new bigger hdd ofcourse ;-) and migrate the data. also i think the .1 or .2 are extensions of the datafile not index files. index files have seperate id of their own. pg_class have that id in relfilenode. in case i am getting the problem wrong , my query is have you relocated the index files also and created the symlinks ? (using ln -s) Also 7.2.1 is too old an version to use in 7.2.x series 7.2.4 is latest and in 7.3.x 7.3.2 is latest. regds mallah. On Wednesday 26 February 2003 11:56 am, PRAGATI SAVAIKAR wrote: > Hi !! > > We have "PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96" > installed on Linux (RedHat 7.2) > Our database size is 15 GB. > Since the database size was increasing and was about to cross the actual > Hard Disk parttion Size, we moved the datafiles (also the index files) to > another partition and created link to them from the data directory. > This was working fine. > But what we found was , the index files(2 files) were not getting updated > in the new partition, instead postgres had created another index file with > name > "tableID".1 in the original data directory. The size of this file was > 356MB, > The actual size of the data table is 1GB. and there were 2 indexes for the > table. which were of size approximately=150MB. > > But after we created link, those 2 index files were not getting updated, > instead the new file with ".1" extension got created in the data directory > (old parttion) and the same is getting updated everyday. > > We dropped the table but the file with ".1" extension was not getting > removed from data directory. We manually had to remove it. > > 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. > > > Thanks in Advance. > > > > Regards, > Pragati. > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- Regds Mallah ---------------------------------------- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.