Re: Extremely slow queries in pgAdminIII

["Asger Petersen" <asger(at)jo-informatik(dot)dk>]

Title: SV: [pgadmin-support] Extremely slow queries in pgAdminIII

Hi Dave and Magnus

 

I´m not at work today so I will not be able to check anything.

 

The network should function properly and all machines have at least 100 mbit connection.

 

I remember a little peculiarity from my tests yesterday. Executing a query which returns approx 40000 rows is really slow on one machine and fast on another. But if I execute the same query but LIMIT the result to 1 row, the query executes equally fast on both machines. Also as far as I remember EXECUTE ANALYZE is equally fast.

 

Tomorrow I will go through all your questions and propably also upgrade the server to 8.0.1.

 

Regards

Asger

---

Fra: Magnus Hagander [mailto:mha(at)sollentuna(dot)net]
Sendt: lø 19-03-2005 23:35
Til: Dave Page; Asger Petersen; pgadmin-support(at)postgresql(dot)org
Emne: SV: [pgadmin-support] Extremely slow queries in pgAdminIII

>> Ok, i checked the dlls. I assume that pgAdmin will use the first
>> libpq.dll found in the path.
>
>Not necessarily - iirc, it'll use one in the working directory, the
>system32 directory or the path. It's not quite the same on all versions
>of windows either, but I can't find the relevant docs atm.

Couple of places to find it, but
http://msdn.microsoft.com/library/default.asp?url="">
html/secure06122003.asp has it.

It changed in XPSP1 and Win2003 server.


>> The situation is:
>> The database host: win2k, pgAdminIII 1.2.0 installed w.
>> pgInstaller rc2,
>> libpq.dll version 8.0.0.4356. (pgAdmin on this machine is also slow)
>
>OK (you should really upgrade that to 8.0.1!).

Absolutely.


>> Slow client: winXP, pgAdminIII 1.2.0 installed w. installer
>downloaded
>> from pgadmin.org, libpq.dll version 8.0.0.0
>> Fast client: winXP, pgAdminIII 1.2.0 installed w. installer
>downloaded
>> from pgadmin.org, libpq.dll version 8.0.0.0
>
>Hmm, OK. That's my mingw vs vc++ theory out the window :-(

Where does libpq.dll 8.0.0.0 come from?  I thought that we'd
date-stamped the final number since back in the early RCs.


>> Trying to dig deeper into this, I have used psql on the database host
>> and on the fast client. On the host my query took forever whereas it
>> finished in 10 secs on the fast client. So to me it seems
>> pgAdmin is not
>> really the problem here, but now I have no idea where to
>look next :-(
>
>No - it's beginning to sound more like a network issue. Anything odd
>about the network config on any of those machines, or the switches they
>connect to? Firewalls, that sort of thing? Mind you, it's odd that it's
>slow running the client on the server as well....
>
>Magnus - this is the case I mentioned yesterday. There is no obvious
>relationship between libpq versions and slow/fast machines. One of the
>slow machines is the server itself, and it seems that psql is affected
>as well. Any ideas?

Not offhand.
Is it the connection that is slow, or the query runtime?
Any dealings with client side encodings that are different?
Is plain TCP flowing fast between these machines? Other kind of
networking stuff?


//Magnus