Re: Why memory is not used ? Why vacuum so slow ?

=?iso-8859-15?q?Herv=E9=20Piedvache?= <herve@elma.fr> writes:
> Second point ... after importing my dump ... I make a vacuum full analyze of
> my base (in same time because of my caculation of the day before for my
> aggregats and stats tables about 200 000 row deleted and/or inserted for more
> than 20 tables (each)) ... but It takes about 5 hours ...

Don't do vacuum full.  You should not need it in ordinary circumstances,
if you are doing plain vacuums on a reasonable schedule and you have the
FSM parameters set high enough.  (You do not BTW ... with 175000 pages in
this table alone, 10000 FSM pages for the whole database is surely too
low.)

            regards, tom lane