Re: [HACKERS] vacuum analyze

From: Christof Petig <christof(dot)petig(at)wtal(dot)de>
To: Michael Simms <grim(at)argh(dot)demon(dot)co(dot)uk>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] vacuum analyze
Date: 1999-09-08 11:16:59
Message-ID: 37D645A9.CD5194DC@wtal.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

> Let's see ... I know that removing pg_vlock while vacuum is running
> will lead to a coredump after vacuum finishes (it doesn't recover
> cleanly after its attempt to unlink pg_vlock fails). I think I know
> how to fix that but it's not done yet. The same problem could affect
> any error that is detected between vacuum's internal transactions.
> Do you get any error reports in the postmaster log when there is a
> crash?
>
> Beyond that, I don't recall having heard of any recent fixes that affect
> vacuum.
>
> If you can create a reproducible example then more people could poke
> at it, so that seems like the avenue to focus on.
>
> regards, tom lane

Perhaps the bug I reported on pgsql-bugs about a week ago has some relation
to this problem:
I had been able to reproducibly (?) crash postmaster with my example
program (a loop of
update table) combined with several vacuum commands in a seperate task.
As the sice of the table's index grows a failure almost gets certain.

If you think the program might help you, contact me or look into bugs'
archives.

Regards
Christof

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-09-08 13:30:32 Re: [HACKERS] Stability questions RE 6.5 and 6.3.2 & 6.3.2 problems
Previous Message Hiroshi Inoue 1999-09-08 09:42:50 RE: [HACKERS] optimizer pruning problem