Re: [PERFORM] Major performance problem after upgrade from 8.3 to 8.4

2010-09-02 Thread Gerhard Wiesinger
On Thu, 2 Sep 2010, Tom Lane wrote: Gerhard Wiesinger writes: Problem is that PostgreSQL doesn't listen and take much CPU and also disk I/O. 8.3 was shut down cleanly. Hm, you sure about that? What's in the postmaster log? BTW: Do I need other postgres user with a different home directory

Re: [PERFORM] Major performance problem after upgrade from 8.3 to 8.4

2010-09-02 Thread Gerhard Wiesinger
On Thu, 2 Sep 2010, Tom Lane wrote: Gerhard Wiesinger writes: Problem is that PostgreSQL doesn't listen and take much CPU and also disk I/O. 8.3 was shut down cleanly. Hm, you sure about that? What's in the postmaster log? That's the strange thing: I don't have anything in stdout/stderr l

Re: [PERFORM] Major performance problem after upgrade from 8.3 to 8.4

2010-09-02 Thread Tom Lane
Gerhard Wiesinger writes: > Problem is that PostgreSQL doesn't listen and take much CPU and also disk > I/O. 8.3 was shut down cleanly. Hm, you sure about that? What's in the postmaster log? regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performan