Re: Shared row locking, revisited

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Shared row locking, revisited
Date: 2005-04-07 06:34:03
Message-ID: d32kcd$1lh7$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


"Alvaro Herrera" <alvherre(at)dcc(dot)uchile(dot)cl> writes
> Because we can't reuse MultiXactIds at system crash (else we risk taking
> an Id which is already stored in some tuple), we need to XLog it. Not
> at the locking operation, because we don't want to log that one (too
> expensive.) We can log the current value of MultiXactId counter once in
> a while; say, one each (say) 1000 acquisitions. Following a crash, the
> value is restored to the last one logged + 1000. (I think this can be a
> problem if we log one acquisition, then write some tuples, and then
> crash, without flushing the acquisition logged. Maybe a solution is to
> force a flush after logging an acquisition.)
>

Does Oid have a similar problem?

Regards,
Qingqing

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexey Slynko 2005-04-07 07:43:04 About index_build
Previous Message Qingqing Zhou 2005-04-07 06:11:19 Re: Did this issue ever get resolved?