Re: Question on full vacuum clearing waste space

On 6/7/20 6:06 AM, Wenjun Che wrote: Thank you for the quick response. I ran the script from https://wiki.postgresql.org/wiki/Show_database_bloat, which shows "app_event_users" table has 3751936 as wastedbytes. https://bucardo.org/check_postgres/check_postgres.pl.html#bloat "Please note tha

Re: Question on full vacuum clearing waste space

Thank you for the quick response. I ran the script from https://wiki.postgresql.org/wiki/Show_database_bloat, which shows "app_event_users" table has 3751936 as wastedbytes. On Sun, Jun 7, 2020 at 12:32 AM Mohamed Wael Khobalatte < mkhobala...@grubhub.com> wrote: > > On Sat, Jun 6, 2020 at 11:24

Re: Question on full vacuum clearing waste space

On Sat, Jun 6, 2020 at 11:24 PM Wenjun Che wrote: > Hi > > I am testing full vacuum with pg 10.10 on AWS RDS. I noticed for some > tables, the number of waste bytes stays at a few MB after I run full > vacuum. I double-checked that there are no long running transactions, no > orphaned prepared

Question on full vacuum clearing waste space

Hi I am testing full vacuum with pg 10.10 on AWS RDS. I noticed for some tables, the number of waste bytes stays at a few MB after I run full vacuum. I double-checked that there are no long running transactions, no orphaned prepared transactions and no abandoned replication slots. Here is outpu