> I've seen problems on a 1GB network some weeks ago, which
> disappeared as soon as an *additional* 1GB switch was
> inserted into the network. This could have been caused by
> large frames or so, I wasn't able to dig further (e.g. NIC
> parameters).
There is a thread on pgsql-general which m
Asger Petersen wrote:
Hi again
The network traffic is constant at 0.3 Mbit (connection is 1GBit) for
approx 410 secs. Then I'm asked whether i really want to fetch 37000
rows. If I accept it takes approx 19 secs to retrieve the rows.
On the fast client the same query results in 10Mbits of network t
PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Asger Petersen
> Sent: 21 March 2005 12:12
> To: Magnus Hagander; Dave Page; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Extremely slow queries in pgAdminIII
>
> Hi again
>
> Now i uninstalled 8.
Hi again
Now i uninstalled 8.0rc2 and installed a 8.0.1 on the server. I also
copied the libpq.dll (v. 8.0.1.5031) to the slow client and did the
simple test again. Same result :-( I'm sure that the slow client uses
the new libpq, as this is the only version of the file on the machine.
The client
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
>> 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
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Asger Petersen
> Sent: 19 March 2005 11:53
> To: Dave Page; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Extremely slow queries in pgAdminIII
>
>
> > 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
Hi Dave, thanks for your answer.
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 r
> -Original Message-
> From: Asger Petersen [mailto:[EMAIL PROTECTED]
> Sent: 18 March 2005 17:34
> To: Dave Page; pgadmin-support@postgresql.org
> Subject: RE: [pgadmin-support] Extremely slow queries in pgAdminIII
>
> Hi Dave, thanks for your answer.
Drat - I d
Hi list
We are using pgAdminIII to access a postgresql 8.0.0 rc2 on a win2k
machine.
The problem is, that performance of queries done with pgAdmin varies
extremely between clients. For instance we have two winXp machines w.
pgAdminIII v. 1.2.0. Executing a simple 'SELECT * FROM sometable' w.
4000
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Asger Petersen
> Sent: 18 March 2005 14:37
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Extremely slow queries in pgAdminIII
>
> Hi list
>
12 matches
Mail list logo
