>
>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