Libpq is very slow on windows but fast on linux.

Поиск
Список
Период
Сортировка
От Rob Brown-Bayliss
Тема Libpq is very slow on windows but fast on linux.
Дата
Msg-id AANLkTi=1RvQrdwxkB2dqJH_0ZQ+bFF3zdwD-9zwEUEHP@mail.gmail.com
обсуждение исходный текст
Ответы Re: Libpq is very slow on windows but fast on linux.  (Joe Conway <mail@joeconway.com>)
Re: Libpq is very slow on windows but fast on linux.  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Hi

I have a problem with libpq on windows. Connecting to a db and running
a "select * from some_table;" is very slow.

The table has only 1800 rows, 7 columns. No blobs etc.

The query is taking around 3500ms, in linux it takes around 800ms.
(About 500ms is network time, the server is on the opposite side of
the world from my location.)

The hardware is identical (dual boot)

Why does this so long in windows? I tested in pqsl, and pgadmin to
rule out errors in the app code.

Any advice or clues?  I need the app to work on both platforms.


Thanks
--
--

Rob

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

Предыдущее
От: Alexander Farber
Дата:
Сообщение: Finding rank of a single record
Следующее
От: Joe Conway
Дата:
Сообщение: Re: Libpq is very slow on windows but fast on linux.