| 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: | Whole Thread | Raw Message | 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. |