Re: FreeBSD upgrade causes performance degredation

Поиск
Список
Период
Сортировка
От Peter Schmidt
Тема Re: FreeBSD upgrade causes performance degredation
Дата
Msg-id NEBBJGEFMKLFIKBKBDIDEEANCOAA.peterjs@home.com
обсуждение исходный текст
Ответ на Re: FreeBSD upgrade causes performance degredation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>
> I don't see why an OS change would affect this though; I think you still
> have more digging to do to understand the issue.  Did you reinstall
> Postgres after the OS update, and if so is it possible you neglected to
> do VACUUM ANALYZE after reloading the database?

Postgres was installed after the OS update. All databases are vacuum
analyzed during installation of our product. Definitely more digging to do.

Peter


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: backup file system
Следующее
От: wiecha@airdata.ag (mwi)
Дата:
Сообщение: serious performance problem