Re: Reduction in WAL for UPDATEs

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas ADI SD
Тема Re: Reduction in WAL for UPDATEs
Дата
Msg-id E1539E0ED7043848906A8FF995BDA57901E7B00A@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: Reduction in WAL for UPDATEs  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Reduction in WAL for UPDATEs  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> > I agree that these values need a second look. I think a
> > TOAST_TUPLE_THRESHOLD well smaller than the current value would
still
> > easily pay its way. With a little caution to avoid wasting too much
> > effort on the last few bytes I suspect even as low as
> 400-500 bytes is probably worthwhile.

But a seq scan (or non cached access) would suddenly mutate to multiple
random accesses, so this is not a win-win situation.

Btw: Do we consider the existance of toasted columns in the seq-scan
cost estimation ?

Andreas


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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: ECPG regression tests expected files
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Reduction in WAL for UPDATEs