Re: Major performance problem after upgrade from 8.3 to 8.4

Поиск
Список
Период
Сортировка
От Gerhard Wiesinger
Тема Re: Major performance problem after upgrade from 8.3 to 8.4
Дата
Msg-id alpine.LFD.2.01.1009031837550.28047@bbs.intern
обсуждение исходный текст
Ответ на Re: Major performance problem after upgrade from 8.3 to 8.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Major performance problem after upgrade from 8.3 to 8.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Fri, 3 Sep 2010, Tom Lane wrote:
> Not even in that pgstartup.log file you sent stderr to?
>
> I have seen cases before where Postgres couldn't log anything because of
> SELinux.  If this is a Red Hat based system, look in the kernel log for
> AVC messages.  If you see any, then SELinux is probably blocking things
> because of the nonstandard directory locations.  Turning it off
> temporarily would be the easiest fix, though relabeling the files would
> be a better one.

SELinux is already disabled.
cat /etc/selinux/config | grep -v "^#"|grep -v "^$"
SELINUXTYPE=targeted
SELINUX=disabled

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

I tried to redirect it to a different, new file, on startup I get nothing,
after killing it I get:
2010-09-03 16:35:39.177 GMT [2149] @/: LOG:  could not stat "/usr/share/doc/xalan-j2-manual-2.7.0/apidocs": No such
fileor directory 

Any ideas?

BTW: Shared memory can't be any issue?

Ciao,
Gerhard

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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Florian Weimer
Дата:
Сообщение: Re: Odd estimation issue with user-defined type
Следующее
От: Kaloyan Iliev Iliev
Дата:
Сообщение: Question about LEFT JOIN and query plan