| From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: disk space usage enlarging despite vacuuming |
| Date: | 2003-05-17 15:47:22 |
| Message-ID: | 3EC6A6E2.22003.1424325@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 14 May 2003 at 15:02, Tzvetan Tzankov wrote:
> hallo,
>
> I use debian package postgresql 7.3.2r1-2, it is set to vacuum every 5
> hours and once weekly (sunday) vacuum -f, aditionally there are some
> session tables which vacuum at 5 minutes, dispite this the disk usage
> enlarges with 300-400MB for about 2 days and in sundey with the full vacuum
> very few MB-s are recovered.
Try reindexing. Space went into indexes is not recovered with vacuum.. That
might help..
HTH
Bye
Shridhar
--
Jim Nasium's Law: In a large locker room with hundreds of lockers, the few
people using the facility at any one time will all have lockers next to each
other so that everybody is cramped.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gianni Mariani | 2003-05-17 15:50:23 | Re: context in plpgsql functions |
| Previous Message | Tom Lane | 2003-05-17 15:19:52 | Re: - what protocol for an Internet postgres |