On Mon, 2005-10-10 at 15:51, CSN wrote:
> I don't have a compiler on this machine. If somebody
> can point me to a copy of pg_filedump for Windows (I
> didn't see any using Google) I'd be happy to use it.
> Or perhaps I could compile it under cygwin.
>
> The hard drive is a Western Digital 200GB JD (SATA),
> if that can be used to determine how badly it lies. ;)
The general rule is that ATA (parallel or serial) drives lie. You can
turn off the write cache, which will make it slower, but then it should
be reliable during a power loss.
Or, put it all on a big UPS and hope the power supply never goes out.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
