| From: | Ryan Mahoney <ryan(at)paymentalliance(dot)net> |
|---|---|
| To: | "Mitch Vincent" <mitch(at)venux(dot)net> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Extrordinarily Poor Performance.... |
| Date: | 2001-05-03 20:24:39 |
| Message-ID: | 5.0.2.1.0.20010503212044.026a2400@paymentalliance.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
!! I haven't ran VACUUM ANALYZE since last night. Just ran it -
performance has improved significantly. I think I am going to have to run
it hourly during this high traffic time. Postmasters are still utilizing
about 100% of the CPU. Is this normal? I am considering increasing the
shmmax again.
Thanks for the help Mitch!
-r
At 09:11 PM 5/3/01 -0400, Mitch Vincent wrote:
> > persistant connections. I vaccum daily, usually has little to no impact
>on
>
> You VACUUM ANALYZE too, don't you?
>
>-Mitch
>
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com)
>Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/plain | 166 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ryan Mahoney | 2001-05-03 20:27:57 | Re: Extrordinarily Poor Performance.... |
| Previous Message | Joel Burton | 2001-05-03 20:17:47 | Re: Replication Docs.. |