Re: vacuum, performance, and MVCC - Mailing list pgsql-hackers

From David Fetter
Subject Re: vacuum, performance, and MVCC
Date
Msg-id 20060622195552.GA19158@fetter.org
Whole thread Raw
In response to Re: vacuum, performance, and MVCC  (Lukas Smith <smith@pooteeweet.org>)
List pgsql-hackers
On Thu, Jun 22, 2006 at 07:01:38PM +0200, Lukas Smith wrote:
> Jochem van Dieten wrote:
> 
> >make the session handler smarter? And if you can't do that, put
> >some logic in the session table that turns an update without
> >changes into a no-op?
> 
> err isnt that one the job of the database?

By no means.  Even if there were zero overhead for this, which there
couldn't be, you'd have a real problem auditing attempted actions.
This would be a very big problem when trying to track down a rogue app
and/or a denial of service attack.

Cheers,
D
-- 
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666                             Skype: davidfetter

Remember to vote!


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: Overhead for stats_command_string et al, take 2
Next
From: Jim Nasby
Date:
Subject: Re: vacuum, performance, and MVCC