On Wed, Oct 12, 2011 at 5:17 PM, Bob Hatfield <bobhatfi...@gmail.com> wrote: >> Something about your setup is suspect. Disks perhaps. > > Disk: Fusion IOdrive (1.2TB NAND drive) > > I've read that one should set wal_sync_method=fsync_writethrough for > Windows servers. It's currently set to open_datasync, I have no idea > what effect that will have other than I've read less performance. > > Thoughts?
have you had any power events? hard shutdowns, etc? I wonder if the problem is in the clog files, and not the heap itself. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
