Re: Performance failure / automatic restart / cron ?

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Performance failure / automatic restart / cron ?
Date: 2003-10-26 23:30:39
Message-ID: 3F9C591F.4040100@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Piotr Trawiński wrote:
> I have this notorious problem: at some point pgsql simply hangs up and
> requires a restart.

May we see the content of pg_stat_activity and the content of
pg_locks ?

> I realize my app is very resource hungry but the thing is that it works great
> with mysql. The problem occurs only with pgsql which i realy need.

You need pgsql or mysql was not enough ? Please no flames here.

Regards
Gaetano Mendola

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2003-10-26 23:41:06 Re: device full ---> postgres will not start
Previous Message Oli Sennhauser 2003-10-26 16:46:31 Relation from database to filename of e.g. table