| 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 |