| From: | MirrorX <mirrorx(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PD_ALL_VISIBLE flag warnings |
| Date: | 2011-08-12 09:01:19 |
| Message-ID: | 1313139679049-4692566.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2011-08-12 13:39:42 | Re: PD_ALL_VISIBLE flag warnings |
| Previous Message | Siva Palanisamy | 2011-08-12 08:47:52 | Re: How to create a stored procedure in PostgreSQL |