Re: Error with index on unlogged table - Mailing list pgsql-hackers

From Amit Langote
Subject Re: Error with index on unlogged table
Date
Msg-id CA+HiwqEOdv_o248vprSOih-YCseAi+A63O6rtSUY+eiTF7_wkQ@mail.gmail.com
Whole thread Raw
In response to Re: Error with index on unlogged table  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Error with index on unlogged table  (Thom Brown <thom@linux.com>)
List pgsql-hackers
On Wednesday, March 25, 2015, Michael Paquier <michael.paquier@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?

Amit



pgsql-hackers by date:

Previous
From: Sawada Masahiko
Date:
Subject: Re: Auditing extension for PostgreSQL (Take 2)
Next
From: Kouhei Kaigai
Date:
Subject: Re: Custom/Foreign-Join-APIs (Re: [v9.5] Custom Plan API)