| 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 | Resend email |
| 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
| 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 |
| 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 |