Re: What does this tell me?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: What does this tell me?
Date: 2002-10-09 03:49:36
Message-ID: 200210090349.g993nab27932@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


I think all it means is that is doesn't need some of the pg_clog files
and is reusing them, basically meaning you are pushing through lots of
transactions. I don't see it as a problem.

---------------------------------------------------------------------------

Josh Berkus wrote:
> Folks,
>
> I'm still having trouble with my massive data transformation procedures
> taking forever to finish. Particularly, many of them will get about
> 1/2 way through, and then I will start seeing this in the log:
>
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E4
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E5
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E6
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E7
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E8
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E9
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000EA
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000EB
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000EC
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000ED
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000EE
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000EF
> 2002-10-08 20:37:13 DEBUG: reaping dead processes
> 2002-10-08 20:37:13 DEBUG: child process (pid 15270) exited with exit
> code 0
>
> ... repeat ad nauseum. The problem is, each "recycle transaction log
> ... reaping dead child process" cycle takes about 4-7 minutes ...
> meaning that the procedure can take up to 1/2 hour to finish, and
> sometimes not finish at all.
>
> Obviously, the system is telling me that it is running out of resources
> somehow. But I'm at my wit's end to figure out what resources,
> exactly. Suggestions?
>
> -Josh Berkus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Sean Chittenden 2002-10-09 03:50:43 Re: What does this tell me?
Previous Message Josh Berkus 2002-10-09 03:46:12 What does this tell me?