Postgres Pro
Downloads
Home   >   mailing lists

Re: Should the docs have a warning about pg_stat_reset()? - Mailing list pgsql-hackers

From Joe Conway
Subject Re: Should the docs have a warning about pg_stat_reset()?
Date
Msg-id 7b5aedea-d5aa-6911-4565-9e9cdf962420@joeconway.com
Whole thread Raw
In response to Re: Should the docs have a warning about pg_stat_reset()?  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: Should the docs have a warning about pg_stat_reset()?
List pgsql-hackers
Tree view 
On 4/13/19 3:42 PM, Tomas Vondra wrote:
> If only we had a way to regularly snapshot the data from within the
> database, and then compute the deltas on that. If only we could insert
> data from one table into another one a then do some analysics on it,
> with like small windows moving over the data or something ...

Why not store deltas separately with their own delta reset command?

Joe

-- 
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development

pgsql-hackers by date:

Previous
From: Darafei "Komяpa" Praliaskouski
Date:
Subject: Re: Berserk Autovacuum (let's save next Mandrill)
Next
From: Tom Lane
Date:
Subject: Re: pg_dump is broken for partition tablespaces