Re: Disc space usage - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: Disc space usage
Date
Msg-id alpine.DEB.1.10.0810081455070.15851@aragorn.flymine.org
Whole thread Raw
In response to Re: Disc space usage  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Disc space usage
Re: Disc space usage
List pgsql-performance
On Wed, 8 Oct 2008, Tom Lane wrote:
> The interesting question is how it got that way, and in particular how
> you seem to have managed to have repeated instances of it.

Speaking to some of my colleagues, sometimes the createdb process fails
with a very specific error message. If we wait five seconds and try again,
then it succeeds. So, maybe the duff directories are from those failures.

The error message is always something like this:

createdb: database creation failed: ERROR:  could not stat file "base/32285287/32687035": No such file or directory

Just before running createdb, we always have some quite heavy write
traffic. Is it possible that the changes that we just wrote haven't been
checkpointed properly yet, resulting in some of those files being missing
from the template database, and therefore the createdb to fail?

Matthew

--
Now, you would have thought these coefficients would be integers, given that
we're working out integer results. Using a fraction would seem really
stupid. Well, I'm quite willing to be stupid here - in fact, I'm going to
use complex numbers.                    -- Computer Science Lecturer

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Disc space usage
Next
From: Tom Lane
Date:
Subject: Re: Disc space usage