On Friday, August 12, 2011 2:01:19 am MirrorX wrote: > 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
By any chance have you used pg_upgrade to populate the database? See the these messages for something similar: http://archives.postgresql.org/pgsql-general/2011-04/msg00112.php http://archives.postgresql.org/pgsql-general/2011-04/msg00353.php The second message contains a link to the fix which is included in 8.4.8+. > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/PD-ALL-VISIBLE-flag-warnings-tp469 > 2473p4692566.html Sent from the PostgreSQL - general mailing list archive > at Nabble.com. -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
