On 25 March 2015 at 12:22, Amit Langote <amitlangot...@gmail.com> wrote:
> On Wednesday, March 25, 2015, Michael Paquier <michael.paqu...@gmail.com> > wrote: > > > > On Tue, Mar 24, 2015 at 8:46 PM, Thom Brown wrote: > > > The index is unlogged until reindexing... > > > > > > [...] > > > Which is think also raises the question, why are unlogged indexes made > > > persistent by a reindex? > > > > That's a bug of HEAD, ~9.4 keeping the index as unlogged even after > > REINDEX INDEX. What happens is that ReindexIndex relies on > > relpersistence provided by makeRangeVar at parse time, which is just > > incorrect as it uses RELPERSISTENCE_PERMANENT all the time. The patch > > attached fixes that... > > > > How about VACUUM FULL and CLUSTER as the problem seems to have been > reported to be there too? No, those are okay. They actually revert the index back to the same persistence level as the table they're attached to. -- Thom
