URGENT: pg_statistic_relid_att_index has gone

Поиск
Список
Период
Сортировка
От Harald Lau
Тема URGENT: pg_statistic_relid_att_index has gone
Дата
Msg-id 434123CA.2020708@sector-x.de
обсуждение исходный текст
Ответ на Ultra-cheap NVRAM device  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Ответы Re: URGENT: pg_statistic_relid_att_index has gone  (Harald Lau <harald@sector-x.de>)
Re: URGENT: pg_statistic_relid_att_index has gone  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

on a 7.2 System (Suse-Linux) I got an error "duplicate key in unique
index pg_statistic_relid_att_index" (think it was while vacuuming)

I REINDEXd the database.
Now the table pg_statistic_relid_att_index is completely gone.

Has anybody an advise?

tia,
Harald
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: GnuPT 2.7.2

iQEVAwUBQ0Ejx3fX3+fgcdKcAQIVoQf+MFnt+U65FPNxQjHwZ15eT13NwBoCsOE9
d3nFaKTG58SmI9QziMt1Tpo+pD89LMQZacnCRDv/M3Tz6ruSQaPIsxS6m1evKjq7
7ixSRCwD+41C2x27qSRZDOEUt6AvG5xfSv43NxJQNS/zB+/TnQ3wGXzwdRrRQiQE
Mv6DXv5s+3Wrbg9qG78Xn3mHOGGySFSG1x9ItUoST+jC6a7rOl5YL3wDCacdgve/
pzq3fe6+JYjEQyKFxEzZYJidsWvr9C7EKfc321PYBscuPNyGMU1Vohe8kDYFbyeG
L23jXPV8c7WO2w4aQMdQr6V9YXtnBeMgGdAFjo4My29xbdepkwOUvw==
=I8Ax
-----END PGP SIGNATURE-----

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

Предыдущее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Ultra-cheap NVRAM device
Следующее
От: Harald Lau
Дата:
Сообщение: Re: URGENT: pg_statistic_relid_att_index has gone