Re: PostgreSQL 11 Auto vacuum

2019-06-28 Thread Michael Lewis
> > Actually we have notice that Auto vacuum in PG10 keeps vacuuming the > master tables and that takes a lot of time and Don't go the child table to > remove the dead tuples. > What do the logs say actually got done during these long running autovacuums? Is it feasible to increase the work allo

PostgreSQL 11 Auto vacuum

2019-06-27 Thread Pawan Sharma
Hello All, How the Auto vacuum works on logical partition tables in PostgreSQL 11. Currently, we are using database in PG10 with logical partition of tables and we are facing an performance issue due to large number of bloats. Actually we have notice that Auto vacuum in PG10 keeps vacuuming the