Re: Dumping and reloading stuff in 6.5.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lincoln Yeoh <lylyeoh(at)mecomb(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Dumping and reloading stuff in 6.5.3
Date: 2000-05-15 14:15:53
Message-ID: 26762.958400153@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Lincoln Yeoh <lylyeoh(at)mecomb(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Hoffmann 2000-05-15 14:38:36 Re: rtree indexes aren't being used with 7.0
Previous Message Martijn van Oosterhout 2000-05-15 14:15:43 Re: Best way to "add" columns

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Mount 2000-05-15 14:16:37 RE: lo_unlink
Previous Message Martijn van Oosterhout 2000-05-15 14:12:25 Re: Dumping and reloading stuff in 6.5.3