Contributors mailing list archives
contributors@odoo-community.org
Browse archives
Re: Regular postgres VACUUM command
by
Therp, Tom Blauwendraat
Thanks Moises and Graeme for the detailed information! I'm going to look at tweaking autovacuum and statistics settings for the busy tables. Also, whenever replacing a big chunk of data, I'll run ANALYSE <table> afterwards. As for most situations the default Postgres settings are fine, and I can't think of any "generic" solutions other than monitoring and doing individual tweaks, I won't create an OCA module for it. Parting question: can anyone recommend a visual Postgres monitoring tool that could ideally also work on Amazon RDS? I'm familiar with log parsing tools such as pgBadger, but maybe there's a tool out there somewhere that can give information just by connecting to the instance and running smart queries? -Tom
