Re: GIN fast insert

Robert Haas wrote:
> On Thu, Feb 19, 2009 at 8:36 AM, Teodor Sigaev <teodor@sigaev.ru> wrote:
>>> handle it is not terribly efficient, oh well.  The one thing that
>>> concerns me is - what will happen in a hot standby environment, when
>>> that patch is committed?  In that situation, I believe that we can't
>>> call modify any heap or index pages, so...
>> I don't see a problems here, because indexes in postgres don't depend on any
>> transaction's ids or modes as heap depends. WAL-logger works without that
>> knowledge too. May be I missed something here or don't understand.
>>
>> Although heap's pages could be changed by setting commit-status bits on
>> tuple even in read-only transaction, but that changes are not WAL-logged.
>> That is correct for index's page too.
> 
> It would be helpful if Heikki or Simon could jump in here, but my
> understanding is that cleaning up the pending list is a read-write
> operation.  I don't think we can do that on a hot standby server.

Right, can't do that on a hot standby server.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com