Brian Modra wrote:
> Great Idea, thanks, However, I notice that the postmaster seems idle,
> according to top, only 1% of the CPU at most... is it busy with IO
> maybe? Still seems strange that it sits at 0, or 1% ...
>
> Nothing else is running on the system...
>
> But when I use ps:
>
> postg
2009/9/6 Kevin Kempter :
> On Sunday 06 September 2009 10:28:30 you wrote:
>> Thanks, I suspected that was the case. However, the plain vacuum on
>> the largest table has been running for almost 24 hours now, despite
>> the postgresql being idle (no rows being inserted or updated for 24
>> hours).
On Sunday 06 September 2009 10:28:30 you wrote:
> Thanks, I suspected that was the case. However, the plain vacuum on
> the largest table has been running for almost 24 hours now, despite
> the postgresql being idle (no rows being inserted or updated for 24
> hours). The vacuum full will probably t
On Sunday 06 September 2009 00:05:04 Brian Modra wrote:
> Hi,
> I'm maintaining a fairly large online database, and am trying to free
> up disk space. Its got to 98% full.
> I am certain that the postgresql data files are responsible for more
> than 97% of this partition's usage.
> The WAL logs for
