From: | darcy(at)druid(dot)net (D'Arcy J(dot)M(dot) Cain) |
---|---|
To: | Ryan Mahoney <ryan(at)paymentalliance(dot)net> |
Cc: | Mitch Vincent <mitch(at)venux(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Re: Extrordinarily Poor Performance.... |
Date: | 2001-05-04 12:10:28 |
Message-ID: | 20010504121028.ECA071A6B@druid.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thus spake Ryan Mahoney
> !! 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.
Although it isn't supposed to be necessary, I find that I have to dump and
reload once in a while to keep performance hight.
--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Hirsch | 2001-05-04 12:24:52 | Re: New Linux xfs/reiser file systems |
Previous Message | Dariusz Pietrzak | 2001-05-04 12:05:19 | Permissions and views. |