Re: [GENERAL] Corrupt index

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: [GENERAL] Corrupt index
Дата
Msg-id D056F14D-B32E-4AD8-8F3B-ADC78F694BD3@a-kretschmer.de
обсуждение исходный текст
Ответ на Re: [GENERAL] Corrupt index  (Daryl Stultz <daryl.stultz@opentempo.com>)
Ответы Re: [GENERAL] Corrupt index  (John R Pierce <pierce@hogranch.com>)
Список 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 по дате отправления:

Предыдущее
От: Daryl Stultz
Дата:
Сообщение: Re: [GENERAL] Corrupt index
Следующее
От: John R Pierce
Дата:
Сообщение: Re: [GENERAL] Corrupt index