Postgres Pro
Downloads
Home   >   mailing lists

Re: auto-vacuum conflicting with long running analyze - Mailing list pgsql-hackers

From Tom Lane
Subject Re: auto-vacuum conflicting with long running analyze
Date
Msg-id 2395.1207429651@sss.pgh.pa.us
Whole thread Raw
In response to auto-vacuum conflicting with long running analyze  (Shane Ambler <pgsql@Sheeky.Biz>)
List pgsql-hackers
Tree view 
Shane Ambler <pgsql@Sheeky.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
multipleANALYZEcommands in a single transaction, to prevent possibledeadlock problems.  Per request from Tom Lane.
 
        regards, tom lane

pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: auto-vacuum conflicting with long running analyze
Next
From: Tom Lane
Date:
Subject: machine-dependent hash_any vs the regression tests