Postgres Pro
Downloads
Home   >   mailing lists

Re: Index use during Hot Standby - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: Index use during Hot Standby
Date
Msg-id 48FCA810.5030402@sigaev.ru
Whole thread Raw
In response to Re: Index use during Hot Standby  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
>> One more thing about GiST - when database is switched from recovery mode to the 
>> normal mode then it's needed to complete insertion in GiST and, possibly, vacuum 
>> index. Dig around GistBulkDeleteResult->needFullVacuum and gistContinueInsert()
> 
> OK, will look at those. (Problems++).
Not a very big issue: in this case index is still in workable state but not very 
effective until vacuum it.

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/

pgsql-hackers by date:

Previous
From: "Hitoshi Harada"
Date:
Subject: Re: Window Functions: buffering strategy
Next
From: Teodor Sigaev
Date:
Subject: Re: Block level concurrency during recovery