Re: [PATCHES] Rewrite sinval messaging to reduce contention

2008-06-19 Thread Tom Lane
I wrote: ... enabling LWLOCK_STATS shows that the contention rate on the sinval locks is now completely negligible --- one block per thousand acquisitions on SInvalWriteLock, and less than one in 1 on SInvalReadLock. The vast majority of the LWLock contention now comes from WALInsertLock

Re: [PATCHES] posix advises ...

2008-06-19 Thread Zoltan Boszormenyi
Greg Smith írta: On Sun, 11 May 2008, Hans-Juergen Schoenig wrote: we also made some simple autoconf hack to check for broken posix_fadvise. Because of how you did that, your patch is extremely difficult to even test. You really should at least scan the output from diff you're about to

Re: [PATCHES] posix advises ...

2008-06-19 Thread Greg Smith
On Thu, 19 Jun 2008, Zoltan Boszormenyi wrote: This patch (revisited and ported to current CVS HEAD) is indeed using Greg's original patch and also added another patch written by Mark Wong that helps evicting closed XLOGs from memory faster. Great, that will save me some trouble. I've got a