Re: BUG #4096: PG 8.3.1. confused about remaining disk space

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: J6M <j6m(at)adm(dot)estp(dot)fr>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4096: PG 8.3.1. confused about remaining disk space
Date: 2008-04-07 18:31:39
Message-ID: 47FA688B.4030208@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

J6M wrote:
> OK. So why did this not occur when I was running 8.2.6 ?

I would advise to install some very detailed monitoring on your
diskspace usage and look for spikes that correlate with your database
errors -. I have seen this issue with bad queries that are resulting in
enormous on-disk sorts and running the box temporary out of diskspace.

Stefan

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Coxhead 2008-04-08 02:30:36 BUG #4100: GMT offsets are wrong
Previous Message felipe macedo 2008-04-07 18:09:39 BUG #4099: backup error