Re: Snapshot too old logging - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Snapshot too old logging
Date
Msg-id CACjxUsMRuH8QJxx-ozJVSC24qj40_6Q_8YX+U7Dfce2idLfQHA@mail.gmail.com
Whole thread Raw
In response to Re: Snapshot too old logging  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
On Wed, Nov 16, 2016 at 6:12 AM, Magnus Hagander <magnus@hagander.net> wrote:
> On Tue, Nov 15, 2016 at 9:23 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:

>> Can this happen for relation types other than tables, say materialized
>> views?  (Your suggested wording omits relation type so it wouldn't be
>> affected, but it's worth considering I think.)
>
>
> I'm fairly certain it can hit other things, including indexes and definitely
> matviews, but I won't say I'm 100% sure :) The check is at block level. Does
> errtable() work for that? (I've never used it, and it seems it's only
> actually use din a single place in the codebase..)

Yes, it can happen for indexes and for materialized views.

-- 
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Password identifiers, protocol aging and SCRAM protocol
Next
From: Amit Kapila
Date:
Subject: Re: Parallel execution and prepared statements