Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.4 open item: copy performance regression? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.4 open item: copy performance regression?
Date
Msg-id 7086.1245423944@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.4 open item: copy performance regression?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Responses Re: 8.4 open item: copy performance regression?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Re: 8.4 open item: copy performance regression?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-hackers
Tree view 
Just eyeing the code ... another thing we changed since 8.3 is to enable
posix_fadvise() calls for WAL.  Any of the complaints want to try diking
out this bit of code (near line 2580 in src/backend/access/transam/xlog.c)?

#if defined(USE_POSIX_FADVISE) && defined(POSIX_FADV_DONTNEED)if (!XLogArchivingActive() &&
(get_sync_bit(sync_method)& PG_O_DIRECT) == 0)    (void) posix_fadvise(openLogFile, 0, 0, POSIX_FADV_DONTNEED);
 
#endif
        regards, tom lane

pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: 8.4 open item: copy performance regression?
Next
From: Peter Eisentraut
Date:
Subject: Re: rc1 tarball contains partially outdated/missing man pages