Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Sean ChittendenDate: 2002-10-09 03:50:43
Subject: Re: What does this tell me?
Previous:From: Josh BerkusDate: 2002-10-09 03:46:12
Subject: What does this tell me?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group