Hi all,
We are experiencing an issue on both of our dspace instances where postmaster
spins up 99% of the CPU. Sometimes it's just one process at 99%, othertimes its
a dozen or more processes around 7-9% each. I ran some stats on postgres via:
select * from pg_stat_activity
I found this query in the output about 15 times:
SELECT bi_item.* FROM bi_item, (SELECT bi_4_dmap.item_id FROM bi_4_dmap,
bi_4_dis WHERE bi_4_dmap.distinct_id=bi_4_dis.id AND bi_4_dis.sort_value=$1 )
mappings WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 ASC LIMIT $2
The earliest has a start time of about 5 hours ago.
Anyone know whats up?
cheers,
Steve
------------------------------------------------------------------------------
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a
Billion" shares his insights and actions to help propel your
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
