On Thu, Nov 5, 2009 at 1:20 PM, S Arvind <arvindwill(at)gmail(dot)com> 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.
--
GJ