I am running a query and getting the following output in the log:
2002-12-23 10:25:20 DEBUG: ProcessQuery 2002-12-23 10:25:20 DEBUG: CommitTransactionCommand 2002-12-23 10:25:20 DEBUG: StartTransactionCommand 2002-12-23 10:25:20 DEBUG: query: fetch 1000 from my_cursor 2002-12-23 10:25:20 DEBUG: ProcessUtility: fetch 1000 from my_cursor 2002-12-23 10:30:10 DEBUG: proc_exit(0) 2002-12-23 10:30:10 DEBUG: shmem_exit(0) 2002-12-23 10:30:10 DEBUG: exit(0) /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: CleanupProc: pid 16940 exited with status 0 2002-12-23 10:35:10 DEBUG: proc_exit(0) 2002-12-23 10:35:10 DEBUG: shmem_exit(0) 2002-12-23 10:35:10 DEBUG: exit(0) /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: CleanupProc: pid 16947 exited with status 0 2002-12-23 10:40:10 DEBUG: proc_exit(0) 2002-12-23 10:40:10 DEBUG: shmem_exit(0) 2002-12-23 10:40:10 DEBUG: exit(0) /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: CleanupProc: pid 16967 exited with status 0
The last five lines repeat again and again exactly every five minutes. postmaster is using up to 90% of the CPU at times and is staying above 70% for most of the time. I looked in the database directory, "/dioh/DIOH_db/data/base/18722" and there have been no file changes since this query started.
system info: OS: Red Hat 7.2 Kernal : 2.4.7-10smp pg: 7.1
Any ideas?
TIA
Devinder Rajput Stores Division Corporate Offices Chicago, IL (773) 442-6474