Re: PD_ALL_VISIBLE flag warnings
| От | MirrorX |
|---|---|
| Тема | Re: PD_ALL_VISIBLE flag warnings |
| Дата | |
| Msg-id | 1313139679049-4692566.post@n5.nabble.com обсуждение |
| Ответ на | PD_ALL_VISIBLE flag warnings (MirrorX <mirrorx@gmail.com>) |
| Ответы |
Re: PD_ALL_VISIBLE flag warnings
|
| Список | pgsql-general |
i wiil provide some info in case it is helpful -the error msg is -> WARNING: PD_ALL_VISIBLE flag was incorrectly set in relation "summary_data" page 54 (the same thing appears for many tables and many pages on each table) -in my internet searching i found some cases where this issue was related to vacuum operations. in this server, autovacuum is on and working on these tables (since there are updates/deletes there). would it help to turn autovacuum off, run manually vacuums once a day (to those tables needing it, which is determined by the system params) and check the logs? what is strange, is that these messages appear only on 1 db of the server, tha smallest one. and never for the other -- View this message in context: http://postgresql.1045698.n5.nabble.com/PD-ALL-VISIBLE-flag-warnings-tp4692473p4692566.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
В списке pgsql-general по дате отправления: