Re: REINDEX INDEX results in a crash for an index of pg_class since9.6

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: REINDEX INDEX results in a crash for an index of pg_class since9.6
Дата
Msg-id 20190501193947.iny6qngltwnaasgc@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: REINDEX INDEX results in a crash for an index of pg_class since9.6  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Hi,

On 2019-05-01 10:21:15 -0700, Andres Freund wrote:
> FWIW, the dirty-hack version (attached) of the CommandCounterIncrement()
> approach fixes the issue for a REINDEX pg_class_oid_index; in solation
> even when using CCA. Started a whole CCA testrun with it, but the
> results of that will obviously not be in quick.

Not finished yet, but it got pretty far:

parallel group (5 tests):  create_index_spgist index_including_gist index_including create_view create_index
     create_index                 ... ok       500586 ms
     create_index_spgist          ... ok        86890 ms
     create_view                  ... ok       466512 ms
     index_including              ... ok       150279 ms
     index_including_gist         ... ok       109087 ms
test reindex_catalog              ... ok         2285 ms
parallel group (16 tests):  create_cast roleattributes drop_if_exists create_aggregate vacuum create_am hash_func
selectcreate_function_3 constraints typed_table rolenames errors updatable_views triggers inherit
 

that's where it's at right now:

parallel group (20 tests):  init_privs security_label gin password drop_operator lock gist tablesample spgist


Greetings,

Andres Freund



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Unhappy about API changes in the no-fsm-for-small-rels patch
Следующее
От: Jeff Janes
Дата:
Сообщение: pg_upgrade --clone error checking