Re: An idle thought

Поиск
Список
Период
Сортировка
От Gokulakannan Somasundaram
Тема Re: An idle thought
Дата
Msg-id 9362e74e1003182319t10d46c75x8cdac38ca2195e94@mail.gmail.com
обсуждение исходный текст
Ответ на Re: An idle thought  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
Surely the VM is already update-friendly. If you update a tuple in a
page with the visibility bit set, the bit must be unset or you will get
wrong results.

 
I was referring in the context of index only scans to skip visibility checks. I doubt, whether the visibility map feature to skip visibility checks at the heap can be created without any extra cost to updates/inserts. When a data is compressed then there is more contention for the same block and hence would likely affect DMLs. I hope that's what Tom was also referring to, but not in the visibility map context.

Gokul.

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Getting to beta1
Следующее
От: KaiGai Kohei
Дата:
Сообщение: [BUG] SECURITY DEFINER on call handler makes daemon crash