Thread: 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

---

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Jacques Le Roux
Sent: 16 November 2005 12:53
To: pgadmin-support@postgresql.org
Subject: [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 ?

 

----- Original Message ----- 
From: "Andreas Pflug" <pgadmin@pse-consulting.de>
To: "Jacques Le Roux" <jacques.le.roux@les7arts.com>
Cc: <pgadmin-support@postgresql.org>
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 majordomo@postgresql.org 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 pgadmin@pse-consulting.de ?

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: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Jacques Le Roux
Sent: 16 November 2005 12:53
To: pgadmin-support@postgresql.org
Subject: [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

----- 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: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Jacques Le Roux
Sent: 16 November 2005 12:53
To: pgadmin-support@postgresql.org
Subject: [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