PostgreSQL 11 Auto vacuum - Mailing list pgsql-general

From Pawan Sharma
Subject PostgreSQL 11 Auto vacuum
Date
Msg-id CAKqG8NX-SDiW9NWWtEWwJUNxQYoDGT_cwohHWajM8qEv9FR-7A@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL 11 Auto vacuum
List pgsql-general
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 master tables and  that takes a lot of time and Don't go the child table to remove the dead tuples.

We are doing manually vacuum to overcome.

Regards,
Pawan


pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Re: Enabling checksums on a streaming replica
Next
From: "Brad Nicholson"
Date:
Subject: Re: Re: Re: Enabling checksums on a streaming replica