Re: insert performance for win32

Поиск
Список
Период
Сортировка
От Marc Cousin
Тема Re: insert performance for win32
Дата
Msg-id 200509061713.41559.mcousin@sigma.fr
обсуждение исходный текст
Ответ на Re: insert performance for win32  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Список pgsql-performance
>
> In my experience win32 is par with linux generally with a few gotchas on
> either side.  Are your times with fsync=no? It's much harder to give
> apples-apples comparison with fsync=on for various reasons.
It is with fsync=off on windows, fsync=on on linux

>
> Are you running stats_command_string=on?  Try disabling and compare
> results.
Deactivated on windows, activated on linux

> Is your loading app running locally or on the server?
Yes
>
> I am very interesting in discovering sources of high cpu load problems
> on win32.  If you are still having problems could you get a gprof
> profile together?  There is a recent thread on win32-hackers discussing
> how to do this.
I'll give it a look....
>
> Merlin

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

Предыдущее
От: Matthew Nuzum
Дата:
Сообщение: Re: Postgresql Hardware - Recommendations
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Poor performance of delete by primary key