Re: long vacuum

>
>I'm running PGSQL 7.1.3 and Debian Linux 2.4.14 on an Athlon 1.4Ghz box with
>512MB RAM & IDE drives.
>
>Any thoughts appreciated- I'm trying to decide whether I should cancel the
>vacuum & do an autopsy.

I do a nightly vacuum analyze of databases that are about 2-5 gig.  The
longest one takes 40 seconds.  Something is quite wrong.  Do you have truss
?  I'd truss the vacuum and see where it is spending its time.


>-NF
>
>
>
>--------------------------------------------------------------------------
>Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
>Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster

--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100  ext 242