7.1 performance - Mailing list pgsql-admin

From Thomas Heller
Subject 7.1 performance
Date
Msg-id 9c6n36$2a9t$1@news.tht.net
Whole thread Raw
Responses Re: 7.1 performance
Re: 7.1 performance
List pgsql-admin
Hi there,

i just upgraded my database system from 7.0.3 to 7.1 ... i did a dumpall and
psql -f dump.sql to the new db. the data is in place correctly and its
running fine. but as soon as i put the connections back on to the db the
load raised to 6. prior to the upgrade the system load was an 0.3 ... now it
is at 6.

is this normal for 7.1 to need so much more hardware? i use the same
settings for sort_mem, buffers, etc. just no fsync. I thought 7.1 wouldn't
need that anymore.

Any suggestions that i should do? the performance is really bad now :(

btw: the db is a dedicated p3-800 + 1gig ram + uw scsi drives running
redhat6.2

thanks cu,
thomas



pgsql-admin by date:

Previous
From: Cedar Cox
Date:
Subject: Re: [SQL] select ... for update in plpgsql
Next
From: "cacto.com"
Date:
Subject: Mirror Data Base