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
"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
On Tue, Dec 12, 2017 at 8:15 AM, Mariel Cherkassky
> 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
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