Re: vacuum, performance, and MVCC

Поиск
Список
Период
Сортировка
От D'Arcy J.M. Cain
Тема Re: vacuum, performance, and MVCC
Дата
Msg-id 20060622130805.66da7de2.darcy@druid.net
обсуждение исходный текст
Ответ на Re: vacuum, performance, and MVCC  (Lukas Smith <smith@pooteeweet.org>)
Список pgsql-hackers
On Thu, 22 Jun 2006 19:01:38 +0200
Lukas Smith <smith@pooteeweet.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@druid.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.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: vacuum, performance, and MVCC
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: vacuum, performance, and MVCC