Re: Puzzling full database lock

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Opena <counterveil(at)gmail(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Puzzling full database lock
Date: 2012-02-04 06:00:46
Message-ID: 2805.1328335246@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Christopher Opena <counterveil(at)gmail(dot)com> writes:
> Merlin, thanks for the response. My comments below, but firstly, does
> anyone know if autovacuum is affected by setting a statement_timeout?

It is not; in all recent PG releases, the autovacuum processes are
careful to force a session setting of zero.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Potts 2012-02-04 07:37:40 debugging the server[ module causes server cash]
Previous Message Chris Angelico 2012-02-04 02:19:32 Re: Warning: you don't own a lock of type ExclusiveLock