[pgadmin-support] Slow connections from Windows to Linux

2005-11-16 Thread Jacques Le Roux



I was using the previous pgAdmin version (the one 
packed with Postgres 8.0) on Windows (both 2k and XP). I'm now using the 1.4.0 
version. I'm mainly using it to connect from Windows to an Ubuntu Hoary server 
with PostGres 1.4 on. Previously I encountered very fast connection when opening 
the database server. Now it's very slow (some minutes) and the postmaster task 
on server is using a lot of CPU ressources. Any idea ?
 
Thanks by advance :o)
 
Jacques


Re: [pgadmin-support] Slow connections from Windows to Linux

2005-11-16 Thread Jacques Le Roux




  From: 
  Dave 
  Page 
  To: Jacques Le Roux ; pgadmin-support@postgresql.org 
  
  Sent: Wednesday, November 16, 2005 2:37 
  PM
  Subject: Re: [pgadmin-support] Slow 
  connections from Windows to Linux
  
   
  


From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Jacques Le 
RouxSent: 16 November 2005 12:53To: pgadmin-support@postgresql.orgSubject: 
[pgadmin-support] Slow connections from Windows to 
Linux

I was using the previous pgAdmin version (the 
one packed with Postgres 8.0) on Windows (both 2k and XP). I'm now using the 
1.4.0 version. I'm mainly using it to connect from Windows to an Ubuntu 
Hoary server with PostGres 1.4 on. Previously I encountered very fast 
connection when opening the database server. Now it's very slow (some 
minutes) and the postmaster task on server is using a lot of CPU ressources. 
Any idea ?
 
  Are you 
  using SSL where you weren't previously? Or perhaps logging in pgAdmin (not 
  that that should affect the server's CPU) or PostgreSQL has been set to a very 
  verbose level?
   
  If those 
  are not the issue, then as Andreas says, please try to figure out more about 
  what the server is actually doing.
   
  Regards, 
  Dave
 
Just trying, 
using SSL or not is the same : I 
can't reproduce the problem no more, it's as quick as with previous version. 
Perhaps something else was involveld. If the problem reappears I will try 
Andreas suggestion...
 
Thanks for 
you Help both :o)
 
Jacques


Re: [pgadmin-support] Slow connections from Windows to Linux

2005-11-16 Thread Jacques Le Roux
- Original Message - 
From: "Andreas Pflug" <[EMAIL PROTECTED]>
To: "Jacques Le Roux" <[EMAIL PROTECTED]>
Cc: 
Sent: Wednesday, November 16, 2005 2:29 PM
Subject: Re: [pgadmin-support] Slow connections from Windows to Linux


> Jacques Le Roux wrote:
> > I was using the previous pgAdmin version (the one packed with Postgres
> > 8.0) on Windows (both 2k and XP). I'm now using the 1.4.0 version. I'm
> > mainly using it to connect from Windows to an Ubuntu Hoary server with
> > PostGres 1.4 on. Previously I encountered very fast connection when
> > opening the database server. Now it's very slow (some minutes) and the
> > postmaster task on server is using a lot of CPU ressources. Any idea ?
>
> You'll have to provide more information, specifically what the server
> does (stat_command_string)
>
> Regards,
> Andreas
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly

I'm not using Usenet. I will try to take a look at stat_command_string as soon
as possible, probably tomorrow...

Thanks

Jacques

PS: is it a good practice to CC [EMAIL PROTECTED] ?


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


Re: [pgadmin-support] Slow connections from Windows to Linux

2005-11-16 Thread Jacques Le Roux



Ok, I was too quick : the problem appears not 
during the connection but when I open a database (or perhaps also when I refresh 
one ?). This problem does not appear when I'm using a 8.1 database locally (on a 
Windows 2000 machine) or not (on a "remote" Win Xp machine).
 
As sometimes the connection try to open a database 
first (not sure of that) it confused me.
 
Jacques
 

  - Original Message ----- 
  From: 
  Jacques Le Roux 
  To: pgadmin-support@postgresql.org 
  
  Cc: Dave Page ; Andreas Pflug 
  Sent: Wednesday, November 16, 2005 6:47 
  PM
  Subject: Re: [pgadmin-support] Slow 
  connections from Windows to Linux
  
  
From: 
Dave Page 
    To: Jacques Le Roux ; pgadmin-support@postgresql.org 

Sent: Wednesday, November 16, 2005 2:37 
PM
Subject: Re: [pgadmin-support] Slow 
connections from Windows to Linux

 

  
  
  From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Jacques 
  Le RouxSent: 16 November 2005 12:53To: pgadmin-support@postgresql.orgSubject: 
  [pgadmin-support] Slow connections from Windows to 
  Linux
  
  I was using the previous pgAdmin version (the 
  one packed with Postgres 8.0) on Windows (both 2k and XP). I'm now using 
  the 1.4.0 version. I'm mainly using it to connect from Windows to an 
  Ubuntu Hoary server with PostGres 1.4 on. Previously I encountered very 
  fast connection when opening the database server. Now it's very slow (some 
  minutes) and the postmaster task on server is using a lot of CPU 
  ressources. Any idea ?
   
Are you 
using SSL where you weren't previously? Or perhaps logging in pgAdmin (not 
that that should affect the server's CPU) or PostgreSQL has been set to a 
very verbose level?
 
If those 
are not the issue, then as Andreas says, please try to figure out more about 
what the server is actually doing.
 
Regards, 
Dave
   
  Just 
  trying, using SSL or not is the same : 
  I can't reproduce the problem no more, it's as quick as with previous 
  version. Perhaps something else was involveld. If the problem reappears I 
  will try Andreas suggestion...
   
  Thanks for 
  you Help both :o)
   
  Jacques