To see the last 10 lines of verbose i will need to run vacuum tonight
If a run a reindex before the vacuum full, increase the "speed" of doing vacuum? I found something about it googling.
2008/11/26 Scott Marlowe <scott.marlowe@xxxxxxxxx>
2008/11/26 Rafael Domiciano <rafael.domiciano@xxxxxxxxx>:
> The database has around 40 Gb.You didn't mention if you were using autovacuum or not. You also
> If I not use vacuum full everyday the database get very slow.
>
> There is no deadlock on the database.
didn't mention whether or not you'd tried regular vacuums if for some
reason you can't use autovacuum. Vacuum full is very intrusive and
can cause index bloat. It's more of a repair operation than a routine
maintenance one.
What do the last 10 or so lines of vacuum verbose run as a super user say?