[HACKERS] auto-vacuum conflicting with long running analyze

2008-04-05 Thread Shane Ambler
I am currently attempting to import the world street map data as currently available from openstreetmap.org and am wondering if I will come across a possible problem that is mentioned on their website, which appears to be relevant for 8.1 From http://wiki.openstreetmap.org/index.php/Mapnik

Re: [HACKERS] auto-vacuum conflicting with long running analyze

2008-04-05 Thread Alvaro Herrera
Shane Ambler wrote: Given that the analyze will obviously take a long time, is this scenario likely to happen with 8.3.1? or has it been fixed since 8.1.x? In 8.3, autovacuum cancels itself if it sees it is conflicting with another query. Would this be the issue fixed in 8.1.1? - Prevent

Re: [HACKERS] auto-vacuum conflicting with long running analyze

2008-04-05 Thread Shane Ambler
Alvaro Herrera wrote: Shane Ambler wrote: Given that the analyze will obviously take a long time, is this scenario likely to happen with 8.3.1? or has it been fixed since 8.1.x? In 8.3, autovacuum cancels itself if it sees it is conflicting with another query. Would this be the issue

Re: [HACKERS] auto-vacuum conflicting with long running analyze

2008-04-05 Thread Gregory Stark
Alvaro Herrera [EMAIL PROTECTED] writes: Shane Ambler wrote: Given that the analyze will obviously take a long time, is this scenario likely to happen with 8.3.1? or has it been fixed since 8.1.x? In 8.3, autovacuum cancels itself if it sees it is conflicting with another query. But

Re: [HACKERS] auto-vacuum conflicting with long running analyze

2008-04-05 Thread Tom Lane
Shane Ambler [EMAIL PROTECTED] 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),