1. Mailing Lists
  2. Contributors
  3. Re: Regular postgres VACUUM command

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Overtime calculation in Odoo 15 and OCA

Re: Bulk return of serials from multiple partner locations to wh/stock

Avatar

Re: Regular postgres VACUUM command

by
Therp, Tom Blauwendraat
- 28/07/2023 11:20:49 
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

Reference