Re: WAL recycling, Linux 2.4.18 - Mailing list pgsql-general

From Tom Lane
Subject Re: WAL recycling, Linux 2.4.18
Date
Msg-id 19425.1026156407@sss.pgh.pa.us
Whole thread Raw
In response to Re: WAL recycling, Linux 2.4.18  (Doug Fields <dfields-pg-general@pexicom.com>)
List pgsql-general
Doug Fields <dfields-pg-general@pexicom.com> writes:
> (gdb) where
> #0  0x4028299d in fdatasync () from /lib/libc.so.6
> #1  0x081049ae in pg_fdatasync (fd=53) at fd.c:233
> #2  0x08088276 in issue_xlog_fsync () at xlog.c:3367

Hmm.  That leads to a different line of thought about where the problem
is.  Does the problem go away if you turn off fsync, or select a
wal_sync_method other than fdatasync?  (See postgresql.conf; not sure
if you need a postmaster restart or just SIGHUP to change these.)

            regards, tom lane



pgsql-general by date:

Previous
From: Rod Enke
Date:
Subject: Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion
Next
From: "Jeff MacDonald"
Date:
Subject: Survey on Freebsddiary