Re: Add statistics refresh materialized view - Mailing list pgsql-hackers

From Said Assemlal
Subject Re: Add statistics refresh materialized view
Date
Msg-id e6e8cac6-3d2e-42fc-b1ae-d2fa0e94549e@neurorx.com
Whole thread Raw
In response to Re: Add statistics refresh materialized view  (Seino Yuki <seinoyu@oss.nttdata.com>)
List pgsql-hackers
Hi,


> However, as you said, for most use cases, pg_stat_statements and 
> log_statement may be sufficient.
> I would like to withdraw this proposal.
>
Well, they either require extensions or parameters to be set properly. 
One advantage I see to store those kind of information is that it can be 
queried by application developers (users are reporting old data for 
example).

We currently have to rely on other ways to figure out if materialized 
views were properly refreshed.








pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem while installing PostgreSQL using make
Next
From: Tom Lane
Date:
Subject: Re: Grammar guidelines in Postgres