Re: Dumping and reloading stuff in 6.5.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: Dumping and reloading stuff in 6.5.3
Date
Msg-id 26762.958400153@sss.pgh.pa.us
Whole thread Raw
In response to Dumping and reloading stuff in 6.5.3  (Lincoln Yeoh <lylyeoh@mecomb.com>)
List pgsql-general
Lincoln Yeoh <lylyeoh@mecomb.com> writes:
> Actually, say if I use postgresql on a journalling file system, would this
> problem go away?

Not unless your kernel guarantees to write dirty buffers to disk in the
order they were dirtied, which would be a fairly surprising thing for it
to guarantee IMHO; that's not how Unix buffer caches normally behave.

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Best way to "add" columns
Next
From: Janovszki Levente
Date:
Subject: Re: CREATE FUNCTION problem