Re: Extra files in "base" dir not seen in relfilenodes

2018-01-16 Thread Daniel Farina
On Tue, Jan 16, 2018 at 3:04 PM Tom Lane wrote: > Daniel Farina writes: > > I am looking at a database with a wide (~500G) divergence between the > total > > space expended by the database directory and the result of select > > sum(pg_relation_size(oid)) from pg_class;.

Extra files in "base" dir not seen in relfilenodes

2018-01-16 Thread Daniel Farina
I am looking at a database with a wide (~500G) divergence between the total space expended by the database directory and the result of select sum(pg_relation_size(oid)) from pg_class;. I located about 280G of apparent extra space by performing an anti-join between files on disk and files in the ca