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 ...
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
Thomas Heller [EMAIL PROTECTED] writes:
is this normal for 7.1 to need so much more hardware?
No...
i use the same
settings for sort_mem, buffers, etc. just no fsync. I thought 7.1 wouldn't
need that anymore.
Does the behavior change if you turn off fsync again?