Re: How would you store read/unread topic status?

From: Andres Freund <andres(at)anarazel(dot)de>
To: Alexander Staubo <alex(at)bengler(dot)no>
Cc: Mathieu Nebra <mateo21(at)siteduzero(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: How would you store read/unread topic status?
Date: 2009-06-23 12:43:03
Message-ID: 4A40CDD7.4060904@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 06/23/2009 02:37 PM, Alexander Staubo wrote:
> (That said, I believe PostgreSQL diffs tuple updates, so in practice
> PostgreSQL might not be writing anything if you run an "update" with
> the same value. I will let someone more intimate with the internal
> details of updates to comment on this.)
No, it does not do that by default.
You can write a trigger to do that though - and there is one packaged
with the core version in the upcoming 8.4 version.

Andres

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message justin 2009-06-23 13:57:56 Re: How would you store read/unread topic status?
Previous Message Alexander Staubo 2009-06-23 12:37:10 Re: How would you store read/unread topic status?