Re: [PATCHES] [HACKERS] Hint Bits and Write I/O

2008-06-18 Thread Alvaro Herrera
Simon Riggs wrote: When running a VACUUM command we always dirty the block when setting hint bits, for a number of reasons: * VACUUM FULL expects all hint bits to be set prior to moving tuples * Setting all hint bits allows us to truncate the clog * it forces the VACUUM to write out its own

Re: [PATCHES] small typo in DTrace docs

2008-06-18 Thread Neil Conway
On Fri, 2008-06-13 at 01:49 -0300, Euler Taveira de Oliveira wrote: Attached is a small patch to fix some typos in probes.d path. Applied, thanks. -Neil -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription:

[PATCHES] Rewrite sinval messaging to reduce contention

2008-06-18 Thread Tom Lane
In this thread back in January http://archives.postgresql.org/pgsql-performance/2008-01/msg1.php we saw evidence that contention for SInvalLock was a problem, and we (or at least I) concluded that the sinval messaging system needed a nontrivial rewrite to get rid of its habit of sending

Re: [PATCHES] Simplify formatting.c

2008-06-18 Thread Bruce Momjian
Bruce Momjian wrote: Alvaro Herrera wrote: Bruce Momjian wrote: I moved str_initcap() over into oracle_compat.c and then had initcap() convert to/from TEXT to call it. The code is a little weird because str_initcap() needs to convert to text to use texttowcs(), so in multibyte

Re: [PATCHES] Rewrite sinval messaging to reduce contention

2008-06-18 Thread Tom Lane
I wrote: In this thread back in January http://archives.postgresql.org/pgsql-performance/2008-01/msg1.php we saw evidence that contention for SInvalLock was a problem, and we (or at least I) concluded that the sinval messaging system needed a nontrivial rewrite to get rid of its habit of