Re: Reduction in WAL for UPDATEs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Reduction in WAL for UPDATEs
Date
Msg-id 23723.1175089590@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reduction in WAL for UPDATEs  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-hackers
Kenneth Marshall <ktm@rice.edu> writes:
> We use DSPAM as one of our anti-spam options. Its UPDATE pattern is to
> increment a spam counter or a not-spam counter while keeping the user and
> token information the same. This would benefit from this optimization.

Would it?  How wide is the "user and token" information?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Log levels for checkpoint/bgwriter monitoring
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Reduction in WAL for UPDATEs