Re: index's relpages after table analyzed

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: index's relpages after table analyzed
Дата
Msg-id 200405241205.26170.josh@agliodbs.com
обсуждение исходный текст
Ответ на index's relpages after table analyzed  (Litao Wu <litaowu@yahoo.com>)
Ответы Re: index's relpages after table analyzed  (Litao Wu <litaowu@yahoo.com>)
Список pgsql-performance
Litao,

> I have some tables and there are almost only
> inserts. So I do not care about the "dead tuples",
> but do care about the statistics.

Then just run ANALYZE on those tables, and not VACUUM.
ANALYZE <table-name>;

> My PG version is 7.3.2.

I would suggest upgrading to 7.3.6; the version you are using has several
known bugs.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


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

Предыдущее
От: Litao Wu
Дата:
Сообщение: Re: index's relpages after table analyzed
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Avoiding vacuum full on an UPDATE-heavy table