Re: PG_XLOG grows and grows

From: "Niclas Gustafsson" <niclas(dot)gustafsson(at)codesense(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Cc: <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: PG_XLOG grows and grows
Date: 2002-05-15 14:40:13
Message-ID: 007901c1fc1e$6c815c00$b700a8c0@gmg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ok, I'm running 7.1.2 on the machine with the problem.

I'll be upgrading later on, but for now, is there a
way to see what the "idle in transaction" is waiting
for? As this probably would help us solve some flaw in
Our software?

Regards,

Niclas Gustafsson

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: den 15 maj 2002 16:17
To: Niclas Gustafsson
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] PG_XLOG grows and grows

"Niclas Gustafsson" <niclas(dot)gustafsson(at)codesense(dot)com> writes:
> Every once in a while I observe that our filesystem is running out of
> space due
> to an continous growth of our transaction logs.

Update. This isn't a problem with 7.1.3 and later.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-05-15 15:15:12 Re: PG_XLOG grows and grows
Previous Message Rajesh Kumar Mallah. 2002-05-15 14:35:47 Re: Immortal backend .... (kill -9 ?..)