Postgres Pro
Downloads
Home   >   mailing lists

Re: Why do we let autovacuum give up? - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: Why do we let autovacuum give up?
Date
Msg-id 52E183BB.5050306@catalyst.net.nz
Whole thread Raw
In response to Re: Why do we let autovacuum give up?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Why do we let autovacuum give up?  (Robert Haas <robertmhaas@gmail.com>)
Re: Why do we let autovacuum give up?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Why do we let autovacuum give up?  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Why do we let autovacuum give up?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On 24/01/14 09:49, Tom Lane wrote:
> 2. What have you got that is requesting exclusive lock on 
> pg_attribute? That seems like a pretty unfriendly behavior in itself. 
> regards, tom lane 

I've seen this sort of problem where every db session was busily 
creating temporary tables. I never got to the find *why* they needed to 
make so many, but it seemed like a bad idea.

Regards

Mark

pgsql-hackers by date:

Previous
From: Harold Giménez
Date:
Subject: Re: Why do we let autovacuum give up?
Next
From: Robert Haas
Date:
Subject: Re: Changeset Extraction v7.1