Re: Performance Tuning / RAM Usage - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Performance Tuning / RAM Usage
Date
Msg-id 20020828105538.E4876@mail.libertyrms.com
Whole thread Raw
In response to Re: Performance Tuning / RAM Usage  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Performance Tuning / RAM Usage  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
On Wed, Aug 28, 2002 at 10:40:46AM -0400, Tom Lane wrote:
> Andrew Sullivan <andrew@libertyrms.info> writes:
> > I know that the Debian package does not -- or at least didn't used to
> > -- check for deadlocks at all,
>
> [blinks]  What?

Hmm.  I just checked my home box (where I have the Debian package
installed), and it seems no longer to be the case.  There's no entry
for deadlock_timeout, so the default (1000, IIRC) is what gets used,
I guess.  I have a dim memory, however, of a comment in the old
config file to the effect that the (Debian) default setting of
deadlock_timeout was infinite, i.e. effectively no deadlock checking.

Hmm.  I just checked an ancient box with 6.5 on it, and it's not
there.  Maybe I'm on crack.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance Tuning / RAM Usage
Next
From: "Markus Wollny"
Date:
Subject: Re: Naming-scheme for db-files