Re: vacuum analyze GROWS db ?!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vacuum analyze GROWS db ?!
Дата
Msg-id 29583.1266249045@sss.pgh.pa.us
обсуждение исходный текст
Ответ на vacuum analyze GROWS db ?!  (Marcin Krol <mrkafk@gmail.com>)
Ответы Re: vacuum analyze GROWS db ?!  (Marcin Krol <mrkafk@gmail.com>)
Список pgsql-general
Marcin Krol <mrkafk@gmail.com> writes:
> The app that created this db is written by me for a change. But I've
> done simple VACUUM ANALYZE on the biggest table in db and got this:

Do you *know* that relpages was up to date before that?  If your system
only does manual vacuums then those numbers probably reflected reality
as of your last vacuum.  There are functions that will give you true
file sizes but relpages ain't it.

            regards, tom lane

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

Предыдущее
От: Marcin Krol
Дата:
Сообщение: Selection of index for CLUSTER
Следующее
От: Marcin Krol
Дата:
Сообщение: Re: vacuum analyze GROWS db ?!