What does this tell me?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: What does this tell me?
Date: 2002-10-09 03:46:12
Message-ID: web-1776486@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2002-10-09 03:49:36 Re: What does this tell me?
Previous Message Josh Berkus 2002-10-08 23:36:40 Re: CHAR, VARCHAR, TEXT (Was Large Databases)