Re: abnormal data grow

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