limiting query time and/or RAM

From: Alan McKay <alan(dot)mckay(at)gmail(dot)com>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: limiting query time and/or RAM
Date: 2009-09-17 18:56:42
Message-ID: 844129e80909171156y7df082d4h7298e8ea345542e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
“Don't eat anything you've ever seen advertised on TV”
- Michael Pollan, author of "In Defense of Food"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-09-17 19:00:17 Re: creation of foreign key without checking prior data?
Previous Message Richard Huxton 2009-09-17 18:35:30 Re: 'Weird' errors