Frans wrote:
I'm using Fedora Core 2, apache 2.0 and postgresql 7.4.6.
Recently, the application is slowing down. When I check the process
using "top", sometimes postmaster process time is increasing and the
process is never end, I think this cause the application slowing down
and sometimes this process make the server slowing down and I have to
restart postmaster.
Is there somebody who experience the same problem? and what is the solution?
Are you running vacuum and analyze regularly?
Thank You,
Frans
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
-- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@xxxxxxxxxxxxxxxxx - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL
begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@xxxxxxxxxxxxxxxxx title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
