Re: Extrordinarily Poor Performance.... - Mailing list pgsql-hackers

From Ryan Mahoney
Subject Re: Extrordinarily Poor Performance....
Date
Msg-id 5.0.2.1.0.20010503212044.026a2400@paymentalliance.net
Whole thread Raw
In response to RE: Packaging 7.1.1  (Rachit Siamwalla <rachit@ensim.com>)
Responses Re: Re: Extrordinarily Poor Performance....  (darcy@druid.net (D'Arcy J.M. Cain))
List 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

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

pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Packaging 7.1.1
Next
From: Ryan Mahoney
Date:
Subject: Re: Extrordinarily Poor Performance....