RE: PostgreSQL database size is not reasonable

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 

On Tue, Dec 12, 2017 at 8:15 AM, Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> wrote:

​A​nd the bigger question, Where are the missing 180G ?

​In the toaster probably...

 

 

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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux