On Thu, Nov 5, 2009 at 1:20 PM, S Arvind <arvindwill@xxxxxxxxx> wrote:
Thank Greg and Grzegorz,
As told i have large batch load to the postgres which i need to be run in low priority. Is it really throttling the data will help to lower the postgres workload for some queries?
depends on what you are actually trying to achieve.
If it is an insert of some sort, than divide it up. If it is a query that runs over data, use limits, and do it in small batches. Overall, divide in conquer approach works in these scenarios.
If it is an insert of some sort, than divide it up. If it is a query that runs over data, use limits, and do it in small batches. Overall, divide in conquer approach works in these scenarios.
--
GJ
