Postgres11 vacuum taking days

Asked Aug 12 '22 at 02:26

Active Aug 26 '22 at 03:19

Viewed 47 times

I have set maintenance_work_mem 50GB and trying to run 200GB non partitioned table with 10 indexes manually. I am wondering it is taking 3 days still not completed vacuum.

I know, these many indexes bad but not understanding why vacuum not finished.

Note: No blockings observed

edited Aug 26 '22 at 03:19

asked Aug 12 '22 at 02:26

satya prakash

What does [pg_stat_progress_vacuum](https://www.postgresql.org/docs/11/progress-reporting.html) show? – jjanes Aug 12 '22 at 14:36
100% scan completed and then no change – satya prakash Aug 18 '22 at 17:08
That is your interpretation of what it shows. What does it actually show? As in, cut and paste the literal output (as formatted text). – jjanes Aug 19 '22 at 15:09
Added image to confirm the status is same all the time – satya prakash Aug 26 '22 at 03:20
25GB index scanning took 30 hours, By this time auto vacuum started and blocked by Manual vacuum that already running from 3 days – satya prakash Aug 26 '22 at 07:19

Postgres11 vacuum taking days

0 Answers0