| From: | Shane Ambler <pgsql(at)Sheeky(dot)Biz> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: auto-vacuum conflicting with long running analyze |
| Date: | 2008-04-05 18:37:15 |
| Message-ID: | 47F7C6DB.6070107@Sheeky.Biz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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 fixed in 8.1.1? -
>> Prevent autovacuum from crashing during ANALYZE of expression index
>
> Unrelated.
>
>> Or is it in various autovacuum improvements from 8.3.0 ?
>
> Yes.
>
Sounds good. When it has run through to verify I will get them to update
their notes on that.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2008-04-05 19:06:31 | Re: auto-vacuum conflicting with long running analyze |
| Previous Message | Alvaro Herrera | 2008-04-05 18:29:10 | Re: auto-vacuum conflicting with long running analyze |