Re: postgresql 7.4.6 slowing down

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Frans <fransgunawan(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql 7.4.6 slowing down
Date: 2005-01-31 05:08:54
Message-ID: 41FDBD66.7040608@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org)
>
>

--
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(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachment Content-Type Size
jd.vcf text/x-vcard 285 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-01-31 05:13:49 Re: postgresql 7.4.6 slowing down
Previous Message Steve Wampler 2005-01-31 04:37:25 pg_dump in 7.2.4 with trigger functions