> > And do your disks honour the fsync? Was a power failure the
> cause of this?
>
>
> I have usual office PC using Quantum FireballP LM20.5 20 GB
> IDE HDD with
> XP drivers.
> How to determine is fsync working or not ?
> I use default postgres.conf file ( added only listen_addresses = '*' )
What version exactly was this? There was some changes in 8.0.2 in this
area on win32. The default sync method was also changed at this point.
What's the output of "show wal_sync_method"?
Finally, go into device manager, find your disk, get properties, look
under Policies, is the box for "Enable write caching on the disk"
checked?
//Magnus
---------------------------(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
