Re: auto-vacuum conflicting with long running analyze

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: auto-vacuum conflicting with long running analyze
Date: 2008-04-05 21:07:31
Message-ID: 2395.1207429651@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Shane Ambler <pgsql(at)Sheeky(dot)Biz> writes:
> Would this be the issue fixed in 8.1.1? -
> Prevent autovacuum from crashing during ANALYZE of expression index

More likely this one:

2007-06-14 09:53 alvherre

* src/backend/commands/: vacuum.c (REL8_1_STABLE), vacuum.c
(REL8_2_STABLE), vacuum.c: Avoid having autovacuum run multiple
ANALYZE commands in a single transaction, to prevent possible
deadlock problems. Per request from Tom Lane.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2008-04-05 21:21:22 Re: [HACKERS] Patch queue -> wiki
Previous Message Alvaro Herrera 2008-04-05 20:49:19 Re: [HACKERS] Patch queue -> wiki