Search Postgresql Archives

LargeObjects Total Size

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

 



My pg_largeobject table filenode is 16404:
(select relfilenode from pg_class where relname='pg_largeobject')

Pages (record) count in table pg_largeobject: 73574 -> 144 MB (73574 * 2Kb)
(select count(loid) from pg_largeobject)

Relation pages count (in table pg_class) for table pg_largeobject:
23713 -> 185 MB (23713 * 8 Kb)
(select relpages from pg_class where relname='pg_largeobject')

Total:
144 MB - data in table pg_largeobject
186 MB - size on disk for table pg_largeobject

Question:
185 MB - 144MB = 41 MB - what is in this memory on disk?


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux