Re: [GENERAL] Corrupt index - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: [GENERAL] Corrupt index
Date
Msg-id D056F14D-B32E-4AD8-8F3B-ADC78F694BD3@a-kretschmer.de
Whole thread Raw
In response to Re: [GENERAL] Corrupt index  (Daryl Stultz <daryl.stultz@opentempo.com>)
Responses Re: [GENERAL] Corrupt index
List pgsql-general
On 15 August 2017 21:54:56 GMT+02:00, Daryl Stultz <daryl.stultz@opentempo.com> wrote:
>
>>>We are using PostgreSQL 9.3.14 on a managed Amazon RDS with a
>
>
>>Are you using reindex concurrently? There was a bugfix in 9.3.16 (+-1,
>i'm not sure).
>
>Hi Andreas, not that I'm aware of. I issue "reindex table mytable" to
>get out of the bad situation. I'm not sure if you are saying this bug
>could be getting me into the situation. If you don't mean that I am
>manually executing reindex concurrently, how do I go about determining
>if the system is using that procedure? Perhaps after some transaction,
>the system rebuilds the index automatically using "concurrently" and
>that is buggy/failing?
>
>Thanks.
>
>/Daryl

I only wanted to exclude it. Anyway, you should install the latest patches.


Regards, Andreas.


--
2ndQuadrant - The PostgreSQL Support Company


pgsql-general by date:

Previous
From: Daryl Stultz
Date:
Subject: Re: [GENERAL] Corrupt index
Next
From: John R Pierce
Date:
Subject: Re: [GENERAL] Corrupt index