A followup:
I restarted postgres and within minutes the same query has appeared in the
stats and CPU is back up to 99%. Could we be missing some indexes or something?
We only recently ran the filter-media script and generated thousands of
thumbnails and branded previews but have since performed a vacuum.
Any information would be much appreciated.
cheers,
Steve
On 11/11/2010, at 9:12 AM, Steve Swinsburg wrote:
> 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
>
------------------------------------------------------------------------------
Centralized Desktop Delivery: Dell and VMware Reference Architecture
Simplifying enterprise desktop deployment and management using
Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
client virtualization framework. Read more!
http://p.sf.net/sfu/dell-eql-dev2dev
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
