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@{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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
- [HACKERS] Packaging 7.1.1 Bruce Momjian
- Re: [HACKERS] Packaging 7.1.1 Oleg Bartunov
- Re: [HACKERS] Packaging 7.1.1 Bruce Momjian
- RE: [HACKERS] Packaging 7.1.1 Rachit Siamwalla
- Re: [HACKERS] Packaging 7.1.1 Bruce Momjian
- [HACKERS] Extrordinarily Poor Performan... Ryan Mahoney
- [HACKERS] Re: Extrordinarily Poor P... Ryan Mahoney
- Re: [HACKERS] Extrordinarily P... D'Arcy J.M. Cain
- Re: [HACKERS] Extrordinarily Poor P... Ryan Mahoney
- Re: [HACKERS] Extrordinarily P... Bruce Momjian
- Re: [HACKERS] Extrordinarily Poor P... Lamar Owen
- Re: [HACKERS] Extrordinarily P... Trond Eivind Glomsrød
- [HACKERS] Extrordinarily P... Ryan Mahoney
- Re: [HACKERS] Packaging 7.1.1 Trond Eivind Glomsrød
- Re: [HACKERS] Packaging 7.1.1 Lamar Owen
- Re: [HACKERS] Packaging 7.1.1 Karl DeBisschop
- Re: [HACKERS] Packaging 7.1.1 Lamar Owen
- Re: [HACKERS] Packaging 7.1.1 Lamar Owen