Re: Reducing relation locking overhead - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Reducing relation locking overhead
Date
Msg-id 712.1133629069@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reducing relation locking overhead  (Kevin Brown <kevin@sysexperts.com>)
Responses Re: Reducing relation locking overhead
List pgsql-hackers
Kevin Brown <kevin@sysexperts.com> writes:
> In the above for large relations, the bulk of the REINDEX should
> happen without any locks being held by the REINDEX operation.

As I just pointed out to Greg, the arm-waving notion that you can "turn
off the FSM" requires a great deal of low-level locking that is not
there now.  Even ignoring that, you *still* have a lock upgrade problem
in this sketch.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange left join problems in 8.1
Next
From: Kevin Brown
Date:
Subject: Re: Reducing relation locking overhead