Re: [ADMIN] Vacuum error on database postgres

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, andy <andy(at)squeakycode(dot)net>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [ADMIN] Vacuum error on database postgres
Date: 2006-09-15 13:41:01
Message-ID: 23983.1158327661@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-admin pgsql-hackers

Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> For stuff run from autovacuum, would it be reasonable for the
> automatically run version to just abort if it sees someone doing the
> same thing?

Not especially --- there's no guarantee that the other guy is going to
commit at all. And autovac is only holding one lock at a time so it's
not a factor in the deadlock issue anyway.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-09-15 13:52:02 Re: Release notes
Previous Message Schoenen, Holger 2006-09-15 13:07:00 backup + restore fails

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2006-09-15 14:01:39 Re: Auto Vacuum not starting unless postgres is restarted
Previous Message Nick Howden 2006-09-15 13:08:32 Auto Vacuum not starting unless postgres is restarted