Thread: Postgres Database Grows

Postgres Database Grows

From
Natalino Picone
Date:
I recently installed postgres (the one that comes with the Red Hat 5) and i
noticied that the databases i use continuously grows... I tried to vacuum
it but it is larger (i tried pg_dump + recreate the db).

Thanks a lot
-------------------------------------------------------------------
Natalino Picone (npicone@working.it) - Responsabile Tecnico
===================================================================
Working Online - Work.Net S.r.l. - Internet Solutions Provider
Via XXV Aprile 37 - 21100 Varese - ITALY
Tel. +39-332-320.720 - Fax +39-332-310.202 - Email info@working.it
===================================================================

Re: [GENERAL] Postgres Database Grows

From
Marin D
Date:
Check for temp files left after crash. They are of the type pg_psort.XXX

Also why did a mail-list split happened if we will send mails to all the
lists? Just choose the most appropriate one...


    Marin


          -= Why do we need gates in a world without fences? =-


On Mon, 18 May 1998, Natalino Picone wrote:

> I recently installed postgres (the one that comes with the Red Hat 5) and i
> noticied that the databases i use continuously grows... I tried to vacuum
> it but it is larger (i tried pg_dump + recreate the db).
>
> Thanks a lot
> -------------------------------------------------------------------
> Natalino Picone (npicone@working.it) - Responsabile Tecnico
> ===================================================================
> Working Online - Work.Net S.r.l. - Internet Solutions Provider
> Via XXV Aprile 37 - 21100 Varese - ITALY
> Tel. +39-332-320.720 - Fax +39-332-310.202 - Email info@working.it
> ===================================================================
>