On Mon, Jan 31, 2005 at 08:28:28AM +0700, 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. Have you investigated what queries are running? See configuration settings like stats_command_string and log_min_duration_statement in the "Run-time Configuration" section of the "Server Run-time Environment" chapter of the documentation: http://www.postgresql.org/docs/7.4/static/runtime-config.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
