Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add auto VACUUM+ANALYZE settings to Postgres Database #147

Open
justb4 opened this issue Sep 24, 2018 · 1 comment
Open

Add auto VACUUM+ANALYZE settings to Postgres Database #147

justb4 opened this issue Sep 24, 2018 · 1 comment

Comments

@justb4
Copy link
Contributor

justb4 commented Sep 24, 2018

Performance on a PG database tables with millions of records can significantly improved by regularly VACUUM-ing tables. See this article here:

When checking the last time tables are vacuumed in a schema, it appears some of the larger tables were not vacummed/analyzed at all!

SELECT relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze  
FROM pg_stat_all_tables  
WHERE schemaname = 'smartem_refined';

result for refined data (now 8 million records in timeseries table):

image

and for GOST data:

image

@justb4 justb4 self-assigned this Sep 24, 2018
@justb4 justb4 assigned gerdos82 and unassigned justb4 Dec 3, 2018
@hylkevds
Copy link

This seems to be urgent. A request to /Observations no longer returns:
https://data.smartemission.nl/gost/v1.0/Observations

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants