We run BSD upgrade on 4.1 ...boot from the CD and select upgrade during the
install. I haven't done anything to tune the postgres config...what is
recommended? Eveything has been running fine out of the box up to this
point. Further analysis indicates this could be a problem with the BSD
upgrade, as performance seems to have improved after a clean install of
FreeBSD 4.4.
Thanks again for you comments.
Peter
> -----Original Message-----
> From: Sean Chittenden [mailto:sean@chittenden.org]
> Sent: Monday, October 29, 2001 12:31 PM
> To: Peter Schmidt
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] FreeBSD upgrade causes performance degredation
>
>
> > FreeBSD 4.1 vs FreeBSD 4.4 on X86
> > Postrgesql 7.03
> >
> > We are experiencing a siginficant drop in performance in some PostgreSQL
> > database operations after upgrading FreeBSD 4.1 to FreeBSD 4.4. Database
> > connections appear to be twice as slow while calling some of our own
> > functions can take 10x longer. Does anyone have any ideas why this is
> > occurring?
>
> When you say upgrading, how'd you upgrade? Source upgrade, or is it a
> build from scratch (CD install)? If it's a build from scratch, I'd
> run through tuning(7) and enable soft-updates if they're not already
> on. When you say it's slower, it sounds like disk-access is slower.
> Have you tuned the postgresql config? -sc