Re: insert performance for win32

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: insert performance for win32
Дата
Msg-id Pine.LNX.4.58.0511040215540.22190@eon.cs
обсуждение исходный текст
Ответ на Re: insert performance for win32  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance

On Thu, 3 Nov 2005, Tom Lane wrote:

>
> On Unix I get a dead flat line (within measurement noise), both local
> loopback and across my LAN.
>
> after 50000 30.20 sec
> after 100000 31.67 sec
> after 150000 30.98 sec
> after 200000 29.64 sec
> after 250000 29.83 sec
>

Confirmed in Linux. And on a winxp machine(sp2) with server, client
together, with (see almost no performance difference) or without my "fake"
write, the observation is still hold for both cases:

after 50000 25.21 sec
after 100000 26.26 sec
after 150000 25.23 sec
after 200000 26.25 sec
after 250000 26.58 sec

In both cases, postgres 67% cpu, psql 15~20%, rest: system process. Kernel
time is 40+% -- where from?

Regards,
Qingqing

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: insert performance for win32
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: insert performance for win32