Re: Server misconfiguration??? - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Server misconfiguration???
Date
Msg-id 434A8129.30308@familyhealth.com.au
Whole thread Raw
In response to Re: Server misconfiguration???  ("Andy" <frum@ar-sd.net>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Compression of text columns
Next
From: Tom Lane
Date:
Subject: Re: Query performance on ILIKE with AND operator...