From: | "Gill, Jeffrey L" <jeffrey(dot)l(dot)gill(at)intel(dot)com> |
---|---|
To: | "Pgsql Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Optimization questions |
Date: | 2002-03-14 01:23:30 |
Message-ID: | 01BDB7EEF8D4D3119D95009027AE999511DD2CDE@FMSMSX33 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Specs: Server RedHat 7.1 2.4.2-2 kernal everything build with Interchange
4.8
I am learning Linux and Postgresql from scratch.
1. Can someone point me to or explain any linux kernal optimizations for
redhat that can made to maximize performance of a postgresql server? I
have briefly looked at Momjian's performance recommendations for the
postgresql database itself, but I wondering if there is more that can be
done?
2. What RAID levels does postgresql support? I don't want to make any
assumptions. I plan to put the data on an EMC Clariion FC4700 with RAID
10 eventually.
3. How much memory does postgresql require? Is there a best known method
for size of memory in relation to the size of the database and expected
growth rate? Is there a way to optimize memory i.e. page free space and
page splitting - this may not be applicable but I have been tasked to
research it.
4. How is Symmetric Multiprocessing Processor (SMP) configured? Can
postgresql take advantage of SMP?
Thanks,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Ragnar Kjørstad | 2002-03-14 13:44:30 | Re: Optimization questions |
Previous Message | Stephan Szabo | 2002-03-14 01:18:32 | Re: Order by clause in 'select distinct'? |