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
directories.
Somebody mentioned pg_l
The system catalogs located in the global directory but the global
directory isnt so big(500K). As I mentioned, the base directory is huge and
the directory 16400 is the biggest inside. I checked some big files inside
the directory 16400 (which represents the commbit database) and for some
there *i
"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 tables,
as well as the indexes, if
On Tue, Dec 12, 2017 at 8:15 AM, Mariel Cherkassky
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 ano
On Tue, Dec 12, 2017 at 8:15 AM, Mariel Cherkassky <
mariel.cherkas...@gmail.com> 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 large data values are store in another
