Re: weird table sizes

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: weird table sizes
Дата
Msg-id 201107241145.50357.adrian.klaver@gmail.com
обсуждение исходный текст
Ответ на Re: weird table sizes  (MirrorX <mirrorx@gmail.com>)
Ответы Re: weird table sizes  (Chris Travers <chris.travers@gmail.com>)
Список pgsql-general
On Saturday, July 23, 2011 3:34:07 pm MirrorX wrote:
> i mentioned the sequences number only b/c it seemed stange and i didnt know
> if it could be related to the "weird" sizes.
>
> now i found something more weird...the autovacuum is ON but on
> pg_stat_user_tables on this specific table tha last_vacuum and
> last_autovacuum are both NULL...how can this happen?

Old stats?  Try manually running ANALYZE against the table.

>
>
> thx a lot for all the help
>


--
Adrian Klaver
adrian.klaver@gmail.com

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

Предыдущее
От: Yan Chunlu
Дата:
Сообщение: Re: streaming replication does not work across datacenter with 20ms latency?
Следующее
От: Chris Travers
Дата:
Сообщение: Re: weird table sizes