| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Andy <frum(at)ar-sd(dot)net> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Server misconfiguration??? |
| Date: | 2005-10-10 14:56:41 |
| Message-ID: | 434A8129.30308@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-10-10 14:58:15 | Re: Query performance on ILIKE with AND operator... |
| Previous Message | Tom Lane | 2005-10-10 14:38:08 | Re: Compression of text columns |