Re: matview scannability rehash (was Re: Drastic performance loss in assert-enabled build in HEAD)

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: matview scannability rehash (was Re: Drastic performance loss in assert-enabled build in HEAD)
Дата
Msg-id 20130404231107.GN5117@eldon.alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: matview scannability rehash (was Re: Drastic performance loss in assert-enabled build in HEAD)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane escribió:
> Noah Misch <noah@leadboat.com> writes:

> > A slight variation on the committed approach would be to add a "_scannable"
> > relation fork.
>
> Not very transaction-safe, I think (consider crash midway through a
> transaction that adds or removes the fork), and in any case orders of
> magnitude more expensive than looking at a pg_class field.  This really
> needs to be catalog state, not filesystem state.

We could revive the pg_class_nt patch proposed a decade ago, perhaps ...

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: matview scannability rehash (was Re: Drastic performance loss in assert-enabled build in HEAD)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: patch to add \watch to psql