Re: postgresql and smp linux kernel
От | Oliver Elphick |
---|---|
Тема | Re: postgresql and smp linux kernel |
Дата | |
Msg-id | 1092049098.13140.220.camel@linda обсуждение исходный текст |
Ответ на | postgresql and smp linux kernel (zhicheng wang <wang_zc@yahoo.co.uk>) |
Список | pgsql-general |
On Mon, 2004-08-09 at 11:10, zhicheng wang wrote: > Dear all > > i have a dedicated server mainly running postgresql, > currently rh-posgtresql-7.3.6.7 (and samba, ypbind > etc). The server is a dual processor machine and the > OS is RHEL AS 3. > > I am currently running kernel-smp-2.4.21-15.0.4.EL. > > My question is: do i need to run smp kernel for > postgresql? What is benefit of it? If I run UP kernel, > what do I lose from the point view of PG? You do not NEED it for Pg, but it will improve performance. Each separate session gets a different process and therefore has a change to run on the second processor concurrently with another session on the first processor. The same goes for any other processes that are running, of course. If you do not use an SMP kernel, one of your processors will sit there for ever doing nothing, which is money down the drain. -- Oliver Elphick olly@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== "Be still before the LORD and wait patiently for him; do not fret when men succeed in their ways, when they carry out their wicked schemes." Psalms 37:7
В списке pgsql-general по дате отправления: