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-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


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 log and 
in pg_log directory and even in syslog.


Thnx.

Ciao,
Gerhard

--
http://www.wiesinger.com/

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


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?

Thnx.

Ciao,
Gerhard

--
http://www.wiesinger.com/

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance