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
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) |