Return-Path: postman 
Delivery-Date: Wed, 27 Oct 93 04:58:00 PDT
Return-Path: postman
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA06237; Wed, 27 Oct 93 04:53:27 -0700
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9310271153.AA06237@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: thorsten@dojo.ruhr.de
Received: from mail.Germany.EU.net by postgres.Berkeley.EDU (5.61/1.29)
	id AA06229; Wed, 27 Oct 93 04:53:20 -0700
Received: by mail.Germany.EU.net(EUnetD-2.3.0.i) via EUnet
	id ON22252; Wed, 27 Oct 1993 12:55:41 +0100
Received: by ruhr.de (/\88/\ Smail3.1.22.1 #22.6)
	id <m0os9Nn-000AkdC@ruhr.de>; Wed, 27 Oct 93 11:49 GMT
Received: by jwd.swb.de with uucp (Smail3.1.28.1 #6)
	id m0os625-0000HaC; Wed, 27 Oct 93 09:15 MET
Received: by dojo.ruhr.de (Linux Smail3.1.28.1 #14)
	id m0ortU2-00051HC; Tue, 26 Oct 93 18:51 
Message-Id: <m0ortU2-00051HC@dojo>
From: thorsten@dojo.ruhr.de (Thorsten Frigger)
Subject: Timeout
To: postgres@postgres.berkeley.edu
Date: Tue, 26 Oct 1993 18:51:06 +0000 ()
X-Mailer: ELM [version 2.4 PL21]
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 721       
Resent-To: postgres-dist
Resent-Date: Wed, 27 Oct 93 04:53:26 PDT

Hi there!

We have a small problem:

This morning someone sent a query to Postgres, which took >1min to process.
Another process using the same database was killed because Postgres
suspected a deadlock (there wasn't one, our system is a bit slow sometimes).
Is there a way to tell Postgres to wait longer before quitting?

I "fixed" the problem by re-compiling with the timeout in src/..../proc.c
changed to 10 minutes but this is of course no solution.

Any suggestions?

Thanks in advance.

-- 
Thorsten Frigger      | "America is the only country that went from barbarism
thorsten@dojo.ruhr.de | to decadence without civilization in between."
                                                               OSCAR WILDE