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

From Greg Stark
Subject Re: Reducing relation locking overhead
Date
Msg-id 87sltadxf6.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Reducing relation locking overhead  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Reducing relation locking overhead
Re: Reducing relation locking overhead
Re: Reducing relation locking overhead
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> What's worse, once you have excluded writes you have to rescan the entire
> table to be sure you haven't missed anything. So in the scenarios where this
> whole thing is actually interesting, ie enormous tables, you're still
> talking about a fairly long interval with writes locked out. Maybe not as
> long as a complete REINDEX, but long.

I was thinking you would set a flag to disable use of the FSM for
inserts/updates while the reindex was running. So you would know where to find
the new tuples, at the end of the table after the last tuple you read.

-- 
greg



pgsql-hackers by date:

Previous
From: "Mario Weilguni"
Date:
Subject: Strange left join problems in 8.1
Next
From: Greg Stark
Date:
Subject: Re: Reducing relation locking overhead