Re: Difference in the size of database size and relations

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: Difference in the size of database size and relations
Дата
Msg-id CAGrpgQ_fr_4m48fSP5rB=aKUFgMPHrvVC-zv8=1z_3qh791ncg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Difference in the size of database size and relations  (Luis <luisico@gmail.com>)
Ответы Re: Difference in the size of database size and relations
Список pgsql-admin
Дерево обсуждения

On Tue, Dec 10, 2013 at 4:43 AM, Luis <luisico@gmail.com> wrote:
Actually the query I used to get the relations sizes also included
indexes and even pg_toast.

Your query appears to be using "pg_relation_size()", try it again with "pg_total_relation_size()" to include indexes and toast tables.

Specifics can be found at: http://www.postgresql.org/docs/current/static/functions-admin.html

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

Предыдущее
От: Luis
Дата:
Сообщение: Re: Difference in the size of database size and relations
Следующее
От: Luis
Дата:
Сообщение: Re: Difference in the size of database size and relations