Re: Disc space usage

On Wed, 8 Oct 2008, Tom Lane wrote:
> One other bit of possibly useful data would be to eyeball the file mod
> times in the orphaned subdirectories. If they were from failed CREATE
> DATABASEs then I'd expect every file in a given directory to have the
> same mod time (modulo the amount of time it takes to copy the DB, which
> is probably not trivial for the DB sizes you're dealing with).

Yes, I did that, and the file modification times were in such a pattern.

> If you could also correlate that to the times you saw CREATE failures
> then it'd be pretty convincing that we know failed CREATEs are the
> issue.

Can't do that until next time it happens, because we don't have the logs
from when it did happen any more.

Matthew

--
Jadzia: Don't forget the 34th rule of acquisition: Peace is good for business.
Quark: That's the 35th.
Jadzia: Oh yes, that's right. What's the 34th again?
Quark: War is good for business. It's easy to get them mixed up.