Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group