Re: Postgresql 'eats' all mi data partition

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tomas Szepe <szepe(at)pinerecords(dot)com>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, Javier Carlos <fjcarlos(at)correo(dot)insp(dot)mx>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgresql 'eats' all mi data partition
Date: 2003-09-26 19:02:46
Message-ID: 25842.1064602966@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tomas Szepe <szepe(at)pinerecords(dot)com> writes:
> I'm afraid so. The weird thing is, we once tried running
> VACUUM FULL followed by REINDEX and although the process
> took ages to complete, it didn't seem to help either. :(

> I'll post whatever debug data I'm asked for, just don't make
> me run VACUUM FULL or REINDEX again please. (A full redump
> is 10-20 times faster. :O)

The output of VACUUM VERBOSE for the problem table(s) would be
interesting.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomas Szepe 2003-09-26 19:06:22 Re: Postgresql 'eats' all mi data partition
Previous Message Tomas Szepe 2003-09-26 18:48:30 Re: Postgresql 'eats' all mi data partition