Skip site navigation (1) Skip section navigation (2)

Re: abnormal data grow

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: reynardh(at)lightsky(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: abnormal data grow
Date: 2004-09-21 15:07:01
Message-ID: 87hdprvey2.fsf@asmodeus.mcnaught.org (view raw or flat)
Thread:
Lists: pgsql-general
Reynard Hilman <reynardmh(at)lightsky(dot)com> writes:

> Hi,
>
> I have been having this problem where the database size suddenly grows
> from the normal size of about 300Mb to 12Gb in one night.
> When I look up the table size, the biggest one is only 41Mb and the
> total of all table size is only 223Mb.
> But in the filesystem data directory the total size is 12Gb. I noticed
> there are 10 files with 1Gb size each:
> 1.1G    25677563
> 1.1G    25677563.1
> 1.1G    25677563.2
> 1.1G    25677563.3
> 1.1G    25677563.4
> 1.1G    25677563.5
> 1.1G    25677563.6
> 1.1G    25677563.7
> 1.1G    25677563.8
> 1.1G    25677563.9

25677563 is the OID of this object.  The different files are segments
of the relation, not duplicates (PG restricts individual data file
size to 1GB).  So look for which relation has that OID--it's quite
possibly an index that is bloating up.

-Doug
-- 
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

In response to

pgsql-general by date

Next:From: Alvaro HerreraDate: 2004-09-21 15:20:33
Subject: Re: abnormal data grow
Previous:From: Tom LaneDate: 2004-09-21 15:05:14
Subject: Re: abnormal data grow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group