Re: Extremely slow queries in pgAdminIII

> -----Original Message-----
> From: Asger Petersen [mailto:asger(at)jo-informatik(dot)dk]
> Sent: 18 March 2005 17:34
> To: Dave Page; pgadmin-support(at)postgresql(dot)org
> Subject: RE: [pgadmin-support] Extremely slow queries in pgAdminIII
>
> Hi Dave, thanks for your answer.

Drat - I don't ever remember it /not/ being that!

> No, all the machines are set to 'Errors only'. It is a bit of
> a mystery
> to me and I'm beginning to really wonder what makes one machine that
> much faster than the others.
>
> Thinking of it the slow machines all have a clean install of
> pgAdmin and
> no other postgreSQL related software. The fast machine (my
> personal) has
> lots of software using postgres. For instance i have found 6 or 7
> different versions of libpq.dll on it.

OK - that might be a clue. The last version of pgAdmin shipped with
libpq.dll built in Visual C++, however, when we shipped it with the
Windows version of PostgreSQL in the pgInstaller package, we used the
Mingw build of libpq from PostgreSQL (future versions of pgAdmin will
also use the Mingw version).

If you check the libpq.dll's, you can tell the Mingw ones because they
will have version numbers stamped on them, whereas the old VC++ don't
iirc (if they do, they certainly shouldn't be 8.x). I'd be interested to
know if this is the cause.

Regards, Dave.