Re: PostgreSQL database size is not reasonable - Mailing list pgsql-performance

From Tom Lane
Subject Re: PostgreSQL database size is not reasonable
Date
Msg-id 9060.1513101571@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL database size is not reasonable  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-performance
Mariel Cherkassky <mariel.cherkassky@gmail.com> 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_largeobject upthread --- that would definitely
be a candidate to be big, if you're using large objects at all.

            regards, tom lane


pgsql-performance by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Re: PostgreSQL database size is not reasonable
Next
From: Dinesh Chandra 12108
Date:
Subject: CPU 100% usage caused by iso-8859-1 postgres process..