Postgres Pro
Downloads
Home   >   mailing lists

Libpq is very slow on windows but fast on linux. - Mailing list pgsql-general

From Rob Brown-Bayliss
Subject Libpq is very slow on windows but fast on linux.
Date
Msg-id AANLkTi=1RvQrdwxkB2dqJH_0ZQ+bFF3zdwD-9zwEUEHP@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Alexander Farber
Date:
Subject: Finding rank of a single record
Next
From: Joe Conway
Date:
Subject: Re: Libpq is very slow on windows but fast on linux.