Re: FreeBSD upgrade causes performance degredation

From: "Peter Schmidt" <peterjs(at)home(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Sean Chittenden" <sean(at)chittenden(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: FreeBSD upgrade causes performance degredation
Date: 2001-11-01 07:10:03
Message-ID: NEBBJGEFMKLFIKBKBDIDEEANCOAA.peterjs@home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stefan Huber 2001-11-01 14:02:46 Re: serious performance problem
Previous Message maha lakshmi 2001-11-01 06:55:22 details