Re: vacuum, performance, and MVCC

Поиск
Список
Период
Сортировка
От Jochem van Dieten
Тема Re: vacuum, performance, and MVCC
Дата
Msg-id f96a9b830606220953i6369796hf18e3631a718068a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: vacuum, performance, and MVCC  ("Mark Woodward" <pgsql@mohawksoft.com>)
Ответы Re: vacuum, performance, and MVCC  (Lukas Smith <smith@pooteeweet.org>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Going for "all green" buildfarm results
Следующее
От: Lukas Smith
Дата:
Сообщение: Re: vacuum, performance, and MVCC