RE: [ADMIN] 7.1 performance

2001-04-27 Thread Mikheev, Vadim
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 ...

[ADMIN] 7.1 performance

2001-04-26 Thread Thomas Heller
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

Re: [ADMIN] 7.1 performance

2001-04-26 Thread Tom Lane
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?