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

From Alvaro Herrera
Subject Re: matview scannability rehash (was Re: Drastic performance loss in assert-enabled build in HEAD)
Date
Msg-id 20130404231107.GN5117@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: matview scannability rehash (was Re: Drastic performance loss in assert-enabled build in HEAD)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: matview scannability rehash (was Re: Drastic performance loss in assert-enabled build in HEAD)
Next
From: Tom Lane
Date:
Subject: Re: patch to add \watch to psql