Re: PostgreSQL database size is not reasonable

2017-12-12 Thread Tom Lane
Mariel Cherkassky writes: > The system catalogs located in the global directory but the global > directory isnt so big(500K). You're operating under false assumptions. Only catalogs marked relisshared are in that directory, other ones are in the per-database

Re: PostgreSQL database size is not reasonable

2017-12-12 Thread Tom Lane
"David G. Johnston" writes: > On Tue, Dec 12, 2017 at 8:15 AM, Mariel Cherkassky < > mariel.cherkas...@gmail.com> wrote: >> And the bigger question, Where are the missing 180G ? > ​In the toaster probably... pg_total_relation_size should have counted the toast

RE: PostgreSQL database size is not reasonable

2017-12-12 Thread Craig McIlwee
On Tue, Dec 12, 2017 at 8:15 AM, Mariel Cherkassky > wrote: ​A​nd the bigger question, Where are the missing 180G ? ​In the toaster probably... https://www.postgresql.org/docs/current/static/storage-toast.html Basically

PostgreSQL database size is not reasonable

2017-12-12 Thread Mariel Cherkassky
In my postgresql 9.6 instance I have 1 production database. When I query the size of all databases : combit=> Select pg_database.datname,pg_size_pretty(pg_database_size(pg_database.datname)) as size from pg_database; datname | size ---+- template0 | 7265 kB combit| 285