Re: An idle thought

Поиск
Список
Период
Сортировка
Искать
От
Gokulakannan Somasundaram
Тема
Re: An idle thought
Дата
Msg-id
9362e74e1003180411q154e48a9hf4d7ddba7a0c29e@mail.gmail.com
Ответ на
Re: An idle thought (Jeff Davis)
Список
Дерево обсуждения
Re: An idle thought Chris Browne <cbbrowne@acm.org>

I didn't mean that we'd want to compress it to the absolute minimum
size. I had envisioned that it would be a simple scheme designed only to
eliminate long runs of identical visibility information (perhaps only
the frozen and always visible regions would be compressed).

The extra level of indirection would be slower, but if we freeze tuples
more aggressively (which would be much cheaper if we didn't have to go
to the heap), there might be a small number of tuples with interesting
visibility information at any particular time.


This should be achievable with current proposal of Heikki, but I think it is useful only for tables which won't have more concurrent operations and on databases without any long running queries. So if we have an option to create a visibiliy map ( on the lines of materialized view ), whenever we want for a table, it would help a good number of use cases, i suppose.

Thanks,
Gokul.
В списке pgsql-hackers по дате отправления
От: Gokulakannan Somasundaram
Дата:
Сообщение: Re: An idle thought
От: Heikki Linnakangas
Дата:
FAQ