Postgres Pro
Downloads
Home   >   mailing lists

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

From Magnus Hagander
Subject Re: Snapshot too old logging
Date
Msg-id CABUevEzMkb3TzD91RCCdn0o8_DUmusJ-RSeN+3p9Xjm6A4P29A@mail.gmail.com
Whole thread Raw
In response to Re: Snapshot too old logging  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Snapshot too old logging  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view
On Tue, Nov 15, 2016 at 7:27 PM, Robert Haas <robertmhaas@gmail.com> wrote:
On Tue, Nov 15, 2016 at 1:18 PM, Magnus Hagander <magnus@hagander.net> wrote:
> Is there value in showing which snapshot as well? Something like:
> DETAIL: snapshot <xyz> is too old to access relation <relation>

IIUC, the granularity is per-block, not per-relation, so that might be
misleading.

Does it help to let the user know which number? I'm not really sure what I'd do with that information, whereas knowing the relation would be very useful.

But we could certainly say "snapshot <xyz> is too old to access block <nnn> of relation <rel>". 

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Patch: Implement failover on libpq connect level.
Next
From: Brad DeJong
Date:
Subject: Re: Snapshot too old logging