On Tue, Dec 12, 2017 at 8:15 AM, Mariel Cherkassky <mariel.cherkas...@gmail.com<mailto:mariel.cherkas...@gmail.com>> wrote:
And the bigger question, Where are the missing 180G ? In the toaster probably... https://www.postgresql.org/docs/current/static/storage-toast.html Basically large data values are store in another table different than both the main table and indexes. David J. The query also says C.relkind <> 'i' which means it’s excluding indexes. Also note that pg_catalog is excluded but LOB data would be stored in pg_catalog.pg_largeobject. That could account for some overlooked space as well. Craig