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

From Jochem van Dieten
Subject Re: vacuum, performance, and MVCC
Date
Msg-id f96a9b830606220953i6369796hf18e3631a718068a@mail.gmail.com
Whole thread Raw
In response to Re: vacuum, performance, and MVCC  ("Mark Woodward" <pgsql@mohawksoft.com>)
Responses Re: vacuum, performance, and MVCC  (Lukas Smith <smith@pooteeweet.org>)
List pgsql-hackers
On 6/22/06, Mark Woodward  wrote:
(..)
> thousand active sessions
(..)
> If an active user causes a session update once a second
(..)
> Generally speaking, sessions aren't updated when they change, they are
> usually updated per HTTP request. The data in a session may not change,
> but the session handling code doesn't know this and simply updates anyway.

So what you are saying is that you are doing hundreds of unnecessary
updates per second and as a result of those unnecessary problems  you
have a performance problem. Why not attack the root of the problem and
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?

Jochem


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Going for "all green" buildfarm results
Next
From: Lukas Smith
Date:
Subject: Re: vacuum, performance, and MVCC