| From: | Naomi Walker <nwalker(at)eldocomp(dot)com> |
|---|---|
| To: | <nickf(at)ontko(dot)com>, "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: long vacuum |
| Date: | 2002-03-04 20:08:15 |
| Message-ID: | 4.2.2.20020304130651.00aefb10@ecint.ecinet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
>
>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(at)ontko(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Scroger | 2002-03-04 23:44:20 | SEMMNI,SEMMNS config for posgres 7.1 under Solaris |
| Previous Message | impala | 2002-03-04 19:35:18 | /etc/rc.d/init.d/postgresql VS usr/bin/pg_ctl |