Re: Server misconfiguration???

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Server misconfiguration???
Дата
Msg-id 434A8129.30308@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Server misconfiguration???  ("Andy" <frum@ar-sd.net>)
Список pgsql-performance
> Yes you're right it really bosst a little.
> I want to improve the system performance. Are there any more tipps?

The rest of the numbers look vaguely ok...

> On this server runs only a webserver with php application which uses
> postgre Db. Should I give more memory to postgre? From what I noticed
> this is the most memory "needing" service from this system.

The best thing you can do is use two servers so that pgsql does not
compete with web server for RAM...  Personally I'd start looking at my
queries themselves next, see where I could optimise them.

Chris

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Compression of text columns
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Query performance on ILIKE with AND operator...