Re: Execution time of UPDATE raises dramatically!

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Execution time of UPDATE raises dramatically!
Дата
Msg-id Pine.LNX.4.30.0202011557490.687-100000@peter.localdomain
обсуждение исходный текст
Ответ на Execution time of UPDATE raises dramatically!  (Vladimir Zamiussky <zami@chat.ru>)
Список pgsql-hackers
Vladimir Zamiussky writes:

> When I do UPDATE some_table set value=... where id=...,
> query execution time raises in arithmetic progression!
> After about 50 updates on every row query consumes ~3 sec against 0.3
> sec as it was at the beginning.
> psql takes  ~80% of CPU time (acording to top).
> VACUUM helps to restore execution speed, but i think it is not the way out.
>
> Is it BUG or FEATURE?

It's just a fact of how the system works.

-- 
Peter Eisentraut   peter_e@gmx.net



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

Предыдущее
От: Vince Vielhaber
Дата:
Сообщение: Re: PostgreSQL crashes with Qmail-SQL
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: TODO Perl documentation question