From: | GB Clark II <postgres(at)vsservices(dot)com> |
---|---|
To: | "Peter Schmidt" <peterjs(at)home(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: FreeBSD upgrade causes performance degredation |
Date: | 2001-11-03 00:53:37 |
Message-ID: | 0111021853371M.82549@prime.vsservices.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Monday 29 October 2001 09:46, Peter Schmidt wrote:
> 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?
>
--SNIP--
What type of drives are running? ATA or SCSI? There have been changes to
both systems since 4.1.
Also, try enabling noatime in fstab for the mount and do a tunefs -n enable
/dev/disk_device to enable softupdates.
GB
--
GB Clark II | Roaming FreeBSD Admin
gclarkii(at)VSServices(dot)COM | General Geek
CTHULU for President - Why choose the lesser of two evils?
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-admin | 2001-11-03 12:50:43 | Re: continuing with rserv replication |
Previous Message | Michael Baker | 2001-11-01 19:37:34 | problems with starting postpostmaster |