On Wednesday, March 25, 2015, Thom Brown <t...@linux.com> wrote: > On 25 March 2015 at 12:22, Amit Langote <amitlangot...@gmail.com > <javascript:_e(%7B%7D,'cvml','amitlangot...@gmail.com');>> wrote: > >> On Wednesday, March 25, 2015, Michael Paquier <michael.paqu...@gmail.com >> <javascript:_e(%7B%7D,'cvml','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. >
Ah, I misread then; sorry about the noise. Amit