> >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 [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
