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 pr
Frans wrote:
I'm using Fedora Core 2, apache 2.0 and postgresql 7.4.6.
Recently, the application is slowing down.
You don't say what the application is.
> When I check the process
using "top", sometimes postmaster process time is increasing and the
process is never end,
The postmaster is supposed t
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 caus
How often are you running vacuumdb ?
On Mon, 31 Jan 2005 08:28:28 +0700, Frans <[EMAIL PROTECTED]> 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 increasin
On Mon, Jan 31, 2005 at 01:20:39PM +0700, Frans wrote:
> last vacuumdb was 5 or 6 months ago, but the transactions is not big
> (about 500-1000 transaction a day). The postmaster did not eating up
> memory, but eating up processor process.
There's your problem. If you don't vacuumdb, then the fil
last vacuumdb was 5 or 6 months ago, but the transactions is not big
(about 500-1000 transaction a day). The postmaster did not eating up
memory, but eating up processor process.
On Sun, 30 Jan 2005 22:13:49 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Mon, Jan 31, 2005 at 08:28:28AM +070
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 th
