Re: Copy slows down; is it normal?

Поиск
Список
Период
Сортировка
От Gene Selkov Jr.
Тема Re: Copy slows down; is it normal?
Дата
Msg-id 199810071857.NAA08243@antares.mcs.anl.gov
обсуждение исходный текст
Список pgsql-admin
Hi Bennett,

Thanks for the heads-up, but I don't believe the multiplicity of the processors is a problem in my case. SMP is just
anotherway of allocating virtual machines. All the time since i486, unix systems did use one VM per process, but now
thatyou have SMP, there are chances that concurrent VMs will run in more than one physical, which does not increase the
per-processperformance but allows you to run more than one process without time sharing, which is great for database
andweb servers. 

> As I know, Linux kernel 2.0.X(RedHat 5.1) does not directly support DUAL
> CPU/ SMP.

It does, but for some reason, this option is not configurable through 'make xconfig' or 'make menuconfig' menus. And it
isnot built into the default kernel. Setting SMP = 1 in the top level Makefile does it. 

> Therefore your system may work as a single 400MHz i586 system
> only.

From each process' standpoint, it always does, unless the process fork()s. Performance-wise, it looks like a single
processormachine for each postgres backend, but it appears multiple for the postmaster. The only difference for the
backendswhile being run on a dual machine is that they do not compete with each other when there are only two of them,
orcompete less when they are many. 

> I heard that Linux 2.1.X support SMP but it is still a developer
> version.

That's what the note in the makefile has always been saying:

# NOTE! SMP is experimental. See the file Documentation/SMP.txt
#

I arrogantly ignored this note for over two years now (since RedHat 4.1, I think). I used SMP in more than a few dual
machines,including the one I am sitting at now, without any problems so far. I believe the feature is worth
recommendingit to others. 

Sincerely,

Gene


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

Предыдущее
От: Andrea Antibo
Дата:
Сообщение: Re: [ADMIN] initdb and WARN
Следующее
От: "Gilley, Charles H."
Дата:
Сообщение: 6.3.2 build, more questions