Index File growing big.

From: PRAGATI SAVAIKAR <pragati(at)phildigital(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Index File growing big.
Date: 2003-02-26 06:26:48
Message-ID: Pine.LNX.4.33.0302261155430.691-100000@minxserver.philnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-02-26 06:39:44 Re: quick question
Previous Message Christopher Kings-Lynne 2003-02-26 06:24:04 quick question

Browse pgsql-performance by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-02-26 07:29:23 Re: Index File growing big.
Previous Message Stephan Szabo 2003-02-26 05:39:56 Re: Superfluous merge/sort