RE: PostgreSQL database size is not reasonable

Поиск
Список
Период
Сортировка
От Craig McIlwee
Тема RE: PostgreSQL database size is not reasonable
Дата
Msg-id DB5PR02MB06939BD6C040664E19305073EE340@DB5PR02MB0693.eurprd02.prod.outlook.com
обсуждение исходный текст
Ответ на Re: PostgreSQL database size is not reasonable  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-performance

 

On Tue, Dec 12, 2017 at 8:15 AM, Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:

​A​nd the bigger question, Where are the missing 180G ?

​In the toaster probably...

 

 

Basically large data values are store in another table different than both the main table and indexes.

 

David J.

 

The query also says C.relkind <> 'i' which means it’s excluding indexes.  Also note that pg_catalog is excluded but LOB data would be stored in pg_catalog.pg_largeobject.  That could account for some overlooked space as well.

 

Craig

В списке pgsql-performance по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: PostgreSQL database size is not reasonable
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL database size is not reasonable