Re: Maintenance question / DB size anomaly...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Maintenance question / DB size anomaly...
Дата
Msg-id 1876.1182307875@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Maintenance question / DB size anomaly...  (Kurt Overberg <kurt@hotdogrecords.com>)
Ответы Re: Maintenance question / DB size anomaly...  (Kurt Overberg <kurt@hotdogrecords.com>)
Список pgsql-performance
Kurt Overberg <kurt@hotdogrecords.com> writes:
> Okay, I've grabbed pg_filedump and got it running on the appropriate
> server.
> I really have No Idea how to read its output though.  Where does the
> ctid from sl_log_1
> appear in the following listing?

ctid is (block number, item number)

> Block    0 ********************************************************
> BTree Meta Data:  Magic (0x00053162)   Version (2)
>                     Root:     Block (1174413)  Level (3)
>                     FastRoot: Block (4622)  Level (1)

This seems to be an index, not the sl_log_1 table.

            regards, tom lane

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

Предыдущее
От: Kurt Overberg
Дата:
Сообщение: Re: Maintenance question / DB size anomaly...
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Volunteer to build a configuration tool