On Wed, Feb 28, 2018 at 02:23:19PM -0800, Andres Freund wrote:
> Hi,
>
> On 2018-02-28 16:16:53 -0600, Justin Pryzby wrote:
> > - did recovery (you could use "needed recovery" instead, but then there's the
> > question of how reliable that field would be);
> > + or: timestamp of most recent recovery (attempt?)
> What'd that be useful for?
Theoretically nothing but conceivably useful if there's an issue with recovery.
I recall various historic things weren't but should have been WAL logged.
> > - local_preload_libraries?
> Hm?
Not sure; but in any case I meant *_preload_libraries.
> > - started in single user mode or with system indices disabled?
> why?
Some of these I suggested just as a datapoint (or other brainstorms I couldn't
immediately reject). A cluster where someone has UPDATED pg_* (even
pg_statistic) or otherwise hacked on I would tend to think about differently
than a "pristine" cluster that's never seen anything more interesting than a
join.
Justin