Re: Running some query in low priority - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: Running some query in low priority
Date
Msg-id 2f4958ff0911050525w678925uc8f63fe966951ef5@mail.gmail.com
Whole thread Raw
In response to Re: Running some query in low priority  (S Arvind <arvindwill@gmail.com>)
Responses Re: Running some query in low priority  (Matthew Wakeling <matthew@flymine.org>)
List pgsql-performance


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

pgsql-performance by date:

Previous
From: S Arvind
Date:
Subject: Re: Running some query in low priority
Next
From: Matthew Wakeling
Date:
Subject: Re: Running some query in low priority