Re: CPU Load 100% when pg_dump start in Postgresql 8.4

Can you not nice the dump process to free up resources during the dump? Of course this will not free up any locks, and will make them hang around longer as the dump is slowed down.

Brent Wood

GIS/DBA consultant
NIWA
+64 (4) 4 386-0300
________________________________________
From: pgsql-general-owner(at)postgresql(dot)org [pgsql-general-owner(at)postgresql(dot)org] on behalf of Prashant Bharucha [prashantbharucha(at)yahoo(dot)ca]
Sent: Wednesday, April 04, 2012 7:48 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] CPU Load 100% when pg_dump start in Postgresql 8.4

Hello Everyone

I facing a big problem ,when pg_dump start .CPU load become 100%.

DB Size 35 GB running with e commerce web site. Insert transaction record successfully but Update transaction is not going through.

Could you please help to figure out where is the problem ?

Thanks
Prashant

--
Please consider the environment before printing this email.
NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.