Re: limiting query time and/or RAM

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Alan McKay <alan(dot)mckay(at)gmail(dot)com>
Cc: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: limiting query time and/or RAM
Date: 2009-09-17 19:10:31
Message-ID: dcc563d10909171210t4ee41e8cq3fe94805b19d3df2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 17, 2009 at 12:56 PM, Alan McKay <alan(dot)mckay(at)gmail(dot)com> wrote:
> Is there any way to limit a query to a certain amount of RAM and / or
> certain runtime?
>
> i.e. automatically kill it if it exceeds either boundary?
>
> We've finally narrowed down our system crashes and have a smoking gun,
> but no way to fix it in the immediate term.  This sort of limit would
> really help us.

Generally speaking work_mem limits ram used. What are your
non-default postgresql.conf settings?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan 2009-09-17 19:16:34 haversine formula with postgreSQL
Previous Message Sam Mason 2009-09-17 19:00:17 Re: creation of foreign key without checking prior data?