Re: sloooow query - Mailing list pgsql-performance

> What happens if you run VACUUM FULL VERBOSE on the Bad database?  Does it
> report lots of rows taken up?

I ran the vacuum for selected tables.  It looks fine, I think, but I amn't
always sure what I am reading in output.

project=# vacuum full verbose classes;
NOTICE:  --Relation classes--
NOTICE:  Pages 5: Changed 0, reaped 2, Empty 0, New 0; Tup 332: Vac 0,
Keep/VTL 0/0, UnUsed 33, MinLen 93, MaxLen 117; Re-using: Free/Avail. Space
3020/2832; EndEmpty/Avail. Pages 0/1.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index class_pkey: Pages 5; Tuples 332: Deleted 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Rel classes: Pages: 5 --> 5; Tuple(s) moved: 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  --Relation pg_toast_595650--
NOTICE:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0,
Keep/VTL 0/0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0;
EndEmpty/Avail. Pages 0/0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index pg_toast_595650_idx: Pages 1; Tuples 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
VACUUM
project=# vacuum full verbose bm_publications;
NOTICE:  --Relation bm_publications--
NOTICE:  Pages 2: Changed 0, reaped 1, Empty 0, New 0; Tup 284: Vac 0,
Keep/VTL 0/0, UnUsed 6, MinLen 52, MaxLen 52; Re-using: Free/Avail. Space
416/416; EndEmpty/Avail. Pages 0/2.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index bm_publications_pkey: Pages 4; Tuples 284: Deleted 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Rel bm_publications: Pages: 2 --> 2; Tuple(s) moved: 0.
        CPU 0.00s/0.01u sec elapsed 0.00 sec.
VACUUM
project=# vacuum full verbose user_common;
NOTICE:  --Relation user_common--
NOTICE:  Pages 21: Changed 0, reaped 19, Empty 0, New 0; Tup 1045: Vac 0,
Keep/VTL 0/0, UnUsed 103, MinLen 117, MaxLen 221; Re-using: Free/Avail.
Space 4080/2968; EndEmpty/Avail. Pages 0/2.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index user_common_pkey: Pages 20; Tuples 1045: Deleted 0.
        CPU 0.01s/0.00u sec elapsed 0.00 sec.
NOTICE:  Rel user_common: Pages: 21 --> 21; Tuple(s) moved: 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  --Relation pg_toast_474892--
NOTICE:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0,
Keep/VTL 0/0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0;
EndEmpty/Avail. Pages 0/0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index pg_toast_474892_idx: Pages 1; Tuples 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
VACUUM
project=# vacuum full verbose bm_subscriptions_rlt;
NOTICE:  --Relation bm_subscriptions_rlt--
NOTICE:  Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 114: Vac 0,
Keep/VTL 0/0, UnUsed 1, MinLen 57, MaxLen 57; Re-using: Free/Avail. Space
872/872; EndEmpty/Avail. Pages 0/1.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index bm_subscriptions_rlt_pkey: Pages 2; Tuples 114: Deleted 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Rel bm_subscriptions_rlt: Pages: 1 --> 1; Tuple(s) moved: 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
VACUUM
project=#