Re: [HACKERS] Re: Performance problem partially identified

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: [HACKERS] Re: Performance problem partially identified
Дата
Msg-id 374F76B8.4BF9F23A@krs.ru
обсуждение исходный текст
Ответ на Re: Performance problem partially identified  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> 
> Further info:
> 
> I think this behavior may be state-dependent.  The first update after
> loading the table rewrites all the blocks, but subsequent ones do not.
> Is it just a matter of marking recently-written tuples as confirmed
> good?  If so, then there is not a problem (or at least, not as big
> a problem as I thought).

Exactly!

One have to run vacuum after loading a big amount of data.

Vadim


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

Предыдущее
От: Vadim Mikheev
Дата:
Сообщение: Re: [HACKERS] Performance problem partially identified
Следующее
От: Vadim Mikheev
Дата:
Сообщение: Re: [COMMITTERS] 'pgsql/src/backend/storage/buffer bufmgr.c'