Re: PostgreSQL database size is not reasonable

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL database size is not reasonable
Дата
Msg-id 9060.1513101571@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL database size is not reasonable  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Mariel Cherkassky
Дата:
Сообщение: Re: PostgreSQL database size is not reasonable
Следующее
От: Dinesh Chandra 12108
Дата:
Сообщение: CPU 100% usage caused by iso-8859-1 postgres process..