performance question
| От | Devinder K Rajput |
|---|---|
| Тема | performance question |
| Дата | |
| Msg-id | OF33F922A1.8CC71E18-ON86256C98.005FE9E2@ipaper.com обсуждение исходный текст |
| Ответы |
Re: performance question
|
| Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: