performance question

Hi all,

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