Re: [HACKERS] Fixing Simms' vacuum problems

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org, Michael Simms <grim(at)argh(dot)demon(dot)co(dot)uk>
Subject: Re: [HACKERS] Fixing Simms' vacuum problems
Date: 1999-09-13 18:22:40
Message-ID: 37DD40F0.8164BA32@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
>
> So, it looks like a solution involves two components: first, being more
> careful to lock system relations appropriately, and second, being sure
> that SI messages are seen soon enough. I think the read-SI-messages-
> at-lock-time code that's already in place for 6.6 will be sufficient for
> the second point, if we are religious about acquiring appropriate locks.
> (BTW, I think that in most cases an appropriate lock on a system table
> will be less strong than AccessExclusiveLock --- Vadim, do you agree?)

ExclusiveLock should be ok.

Vadim

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim Mikheev 1999-09-13 18:30:33 Re: [HACKERS] Vacuum analyze bug CAUGHT
Previous Message Leon 1999-09-13 18:19:50 Re: [HACKERS] Status report: long-query-string changes