Re: HOT - preliminary results

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas ADI SD
Тема Re: HOT - preliminary results
Дата
Msg-id E1539E0ED7043848906A8FF995BDA57901CB0032@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: HOT - preliminary results  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Ответы Re: HOT - preliminary results  ("Pavan Deolasee" <pavan.deolasee@enterprisedb.com>)
Список pgsql-hackers
> > accounts       157895  (initial size)       49284 (increase)
> > accounts_pkey  19709   (initial size)       19705 (increase)
> >
> >
> Just to clarify, the relation size and increase is in number
> of blocks.

The numbers are quite impressive :-) Have you removed the selects on
accounts too ?
Seems that should also show improvements.

Do you prune chains during update also ? This seems important for a
scenario where only few selects but many updates happen.

Andreas



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: CLUSTER, using SHARE UPDATE EXCLUSIVE lock?
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Dead Space Map version 2