pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Grzegorz Jaśkiewicz <gryzman@gmail.com>
To: S Arvind <arvindwill@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Running some query in low priority
Date: Thu, 5 Nov 2009 13:25:20 +0000
Message-ID: <2f4958ff0911050525w678925uc8f63fe966951ef5@mail.gmail.com> (raw)
In-Reply-To: <abf9211d0911050520t72a5d6dfv877ced07077b11@mail.gmail.com>
References: <abf9211d0911050136g48739f0ft53b63f96cddf706@mail.gmail.com>
	<2f4958ff0911050138n3f246b7ck6182cb702ac48e91@mail.gmail.com>
	<407d949e0911050332n5ef355c1y156dcd26aa28d222@mail.gmail.com>
	<abf9211d0911050520t72a5d6dfv877ced07077b11@mail.gmail.com>

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

view thread (8+ messages)  latest in thread

Message-ID: <2f4958ff0911050525w678925uc8f63fe966951ef5@mail.gmail.com>
Permalink:  ../2f4958ff0911050525w678925uc8f63fe966951ef5@mail.gmail.com/
Also on:    postgresql.org/message-id/2f4958ff0911050525w678925uc8f63fe966951ef5@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gryzman@gmail.com, arvindwill@gmail.com
  Subject: Re: Running some query in low priority
  In-Reply-To: <2f4958ff0911050525w678925uc8f63fe966951ef5@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox