Skip site navigation (1) Skip section navigation (2)

Re: Major performance problem after upgrade from 8.3 to 8.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gerhard Wiesinger <lists(at)wiesinger(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Andreas Kretschmer <akretschmer(at)spamfence(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Major performance problem after upgrade from 8.3 to 8.4
Date: 2010-09-03 16:47:04
Message-ID: 24994.1283532424@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Gerhard Wiesinger <lists(at)wiesinger(dot)com> writes:
> On Fri, 3 Sep 2010, Tom Lane wrote:
>> Not even in that pgstartup.log file you sent stderr to?

> Yes, also the redirected log file is empty. Also kernel log is empty.

Huh.  Try strace'ing the process to see what it's doing.

> BTW: Shared memory can't be any issue?

If you're not getting any log messages at all, you've got worse problems
than shared memory.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Gerhard WiesingerDate: 2010-09-03 16:57:02
Subject: Re: Major performance problem after upgrade from 8.3 to 8.4
Previous:From: Gerhard WiesingerDate: 2010-09-03 16:38:53
Subject: Re: Major performance problem after upgrade from 8.3 to 8.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group