Libpq is very slow on windows but fast on linux.

From: Rob Brown-Bayliss <r(dot)brown(dot)bayliss(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Libpq is very slow on windows but fast on linux.
Date: 2010-11-06 23:54:04
Message-ID: AANLkTi=1RvQrdwxkB2dqJH_0ZQ+bFF3zdwD-9zwEUEHP@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2010-11-06 23:59:22 Re: Libpq is very slow on windows but fast on linux.
Previous Message Alexander Farber 2010-11-06 23:18:55 Finding rank of a single record