Re: FreeBSD upgrade causes performance degredation - Mailing list pgsql-admin

From Peter Schmidt
Subject Re: FreeBSD upgrade causes performance degredation
Date
Msg-id NEBBJGEFMKLFIKBKBDIDEEANCOAA.peterjs@home.com
Whole thread Raw
In response to Re: FreeBSD upgrade causes performance degredation  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: backup file system
Next
From: wiecha@airdata.ag (mwi)
Date:
Subject: serious performance problem