Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group