Re: pg_stats_recovery view

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_stats_recovery view
Date: 2012-02-02 21:08:35
Message-ID: 1CF2DED1B9CCC3579917EB9E@apophis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On 2. Februar 2012 17:12:11 +0900 Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:

> If only core developer is interested in this view, ISTM that short
> description for
> each WAL record is not required because he or she can know the meaning of each
> WAL record by reading the source code. No? Adding short descriptions for every
> WAL records seems to be overkill.

Yes, for a developer option alone adding all these *_short_desc functions looks
too much code for too less benefit. However, if someone with less code affinity
is interested to debug his server during recovery, it might be easier for him
to interpret the statistic counters.

Unfortunately i didn't manage to do it this week, but what i'm also interested
in is how large the performance regression is if the track_recovery variable is
activated. Not sure wether it really makes a big difference, but maybe
debugging recovery from a large archive could slow down to a degree, where you
want the GUC but can't afford it?

And, for display purposes, when this is intended for developers only, shouldn't
it be treated like all the other debug options as a DEVELOPER_OPTION, too?

--
Thanks

Bernd

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2012-02-02 21:26:13 NULL's support in SP-GiST
Previous Message Alexander Korotkov 2012-02-02 19:54:37 Re: Fast GiST index build - further improvements