From: | Amit Langote <amitlangote09(at)gmail(dot)com> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Error with index on unlogged table |
Date: | 2015-03-25 13:45:41 |
Message-ID: | CA+HiwqG6jQuFP-k6K1BVApURn8KdV+s9nLy067aX_7YWrVn+Hg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wednesday, March 25, 2015, Thom Brown <thom(at)linux(dot)com> wrote:
> On 25 March 2015 at 12:22, Amit Langote <amitlangote09(at)gmail(dot)com
> <javascript:_e(%7B%7D,'cvml','amitlangote09(at)gmail(dot)com');>> wrote:
>
>> On Wednesday, March 25, 2015, Michael Paquier <michael(dot)paquier(at)gmail(dot)com
>> <javascript:_e(%7B%7D,'cvml','michael(dot)paquier(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2015-03-25 13:53:43 | Re: Error with index on unlogged table |
Previous Message | Thom Brown | 2015-03-25 13:39:55 | Re: Parallel Seq Scan |