Re: vacuum, performance, and MVCC

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: Lukas Smith <smith(at)pooteeweet(dot)org>
Cc: jochemd(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: vacuum, performance, and MVCC
Date: 2006-06-22 17:08:05
Message-ID: 20060622130805.66da7de2.darcy@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 22 Jun 2006 19:01:38 +0200
Lukas Smith <smith(at)pooteeweet(dot)org> 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?

Seems like a lot of work to give the database for special cases. Not
only would it have to compare all fields, it would also have to check
for the behaviour of all rules, triggers and follow chains. Doing this
for each and every update seems like a loss to me.

Some things just make more sense in the framework of the business rules.

--
D'Arcy J.M. Cain <darcy(at)druid(dot)net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2006-06-22 17:23:45 Re: vacuum, performance, and MVCC
Previous Message Jonah H. Harris 2006-06-22 17:07:02 Re: vacuum, performance, and MVCC