> > > I'm attaching a v5 with fp records only for temp tables, so there's
> > > no risk of
> > > instability. As I previously said I'm fine with your two patches, so
> > > unless
> > > you have objections on the fpi test for temp tables or the
> > > documentation
> > >>>
> > > I'm attaching a v5 with fp records only for temp tables, so there's no
> > > risk of
> > > instability. As I previously said I'm fine with your two patches, so
> > > unless
> > > you have objections on the fpi test for temp tables or the documentation
> > > changes, I believe those should
> > There is a higher-level Instrumentation API that can be used with
> > INSTRUMENT_WAL flag to collect the wal usage information. I believe
> > the instrumentation is widely used in the executor code, so it should
> > not be a problem to colelct instrumentation information on autovacuum
> > worke
> > > > Please feel free to work on any extension of this patch idea. I lack
> > > > both time and knowledge to do it all by myself.
> > >
> > > I'm adding a 3rd patch on top of yours to expose the new WAL counters in
> > > pg_stat_database, for vacuum and autovacuum. I'm not really
> > > enthius
> > Please feel free to work on any extension of this patch idea. I lack
> > both time and knowledge to do it all by myself.
>
>
> I'm adding a 3rd patch on top of yours to expose the new WAL counters in
> pg_stat_database, for vacuum and autovacuum. I'm not really enthiusiastic
> with
> this app
> > > On Thu, Mar 5, 2020 at 8:55 PM Kirill Bychik
> > > wrote:
> > > > I wanted to keep the patch small and simple, and fit to practical
> > > > needs. This patch is supposed to provide tuning assistance, catching
> > > > an io heavy query
пт, 6 мар. 2020 г. в 20:14, Julien Rouhaud :
>
> On Thu, Mar 5, 2020 at 8:55 PM Kirill Bychik wrote:
> >
> > > While at it, did you consider adding a full-page image counter in the
> > > WalUsage?
> > > That's something I'd really like to
> I'm quite worried about the stability of those counters for regression tests.
> Wouldn't a checkpoint happening during the test change them?
Agree, stability of test could be an issue, even shifting of write
format or compression method or adding compatible changes could break
such test. Frankly
> вт, 18 февр. 2020 г. в 06:23, Thomas Munro :
> > On Mon, Feb 10, 2020 at 8:20 PM Craig Ringer wrote:
> > > On Wed, 5 Feb 2020 at 21:36, Kirill Bychik
> > > wrote:
> > > > Patch is separated in two parts: core changes and pg_stat_statements
> > >
вт, 18 февр. 2020 г. в 06:23, Thomas Munro :
> On Mon, Feb 10, 2020 at 8:20 PM Craig Ringer wrote:
> > On Wed, 5 Feb 2020 at 21:36, Kirill Bychik wrote:
> > > Patch is separated in two parts: core changes and pg_stat_statements
> > > additions. Essentially the extensio
Hello pgsql-hackers,
Submitting a patch that would enable gathering of per-statement WAL
generation statistics, similar to how it is done for buffer usage.
Collected is the number of records added to WAL and number of WAL
bytes written.
The data collected was found valuable to analyze update-heav
11 matches
Mail list logo
