Tom Lane-2 wrote > Postgres would be completely broken if that were true, because > modifications made to one copy would fail to propagate to other copies. > I don't know where your data came from, but it can't be an accurate > representation of the instantaneous state of the buffer cache. > > ... actually, after looking at your query, I wonder whether the issue > is that you're failing to include database and tablespace in the > grouping key. relfilenode isn't guaranteed unique across directories. > The fork number can matter, too.
thank you I'll add those columns to my query -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
