pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedNetwork permormance under windows
6+ messages / 5 participants
[nested] [flat]
* Network permormance under windows
@ 2005-12-02 13:05 Teracat <info@teracat.com>
0 siblings, 0 replies; 6+ messages in thread
From: Teracat @ 2005-12-02 13:05 UTC (permalink / raw)
To: pgsql-performance
Hello,
We used Postgresql 7.1 under Linux and recently we have changed it to
Postgresql 8.1 under Windows XP. Our application uses ODBC and when we
try to get some information from the server throw a TCP connection, it's
very slow. We have also tried it using psql and pgAdmin III, and we get
the same results. If we try it locally, it runs much faster.
We have been searching the mailing lists, we have found many people with
the same problem, but we haven't found any final solution.
How can we solve this? Any help will be appreciated.
Thanks in advance.
Jordi.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Network permormance under windows
@ 2005-12-02 16:13 Merlin Moncure <merlin.moncure@rcsonline.com>
2005-12-02 17:24 ` Re: Network permormance under windows Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>
0 siblings, 1 reply; 6+ messages in thread
From: Merlin Moncure @ 2005-12-02 16:13 UTC (permalink / raw)
To: Teracat <info@teracat.com>; +Cc: pgsql-performance
> We used Postgresql 7.1 under Linux and recently we have changed it to
> Postgresql 8.1 under Windows XP. Our application uses ODBC and when we
> try to get some information from the server throw a TCP connection,
it's
> very slow. We have also tried it using psql and pgAdmin III, and we
get
> the same results. If we try it locally, it runs much faster.
>
> We have been searching the mailing lists, we have found many people
with
> the same problem, but we haven't found any final solution.
>
> How can we solve this? Any help will be appreciated.
>
> Thanks in advance.
>
by any chance are you working with large tuples/columns (long text,
bytea, etc)?
Also please define slow.
Merlin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Network permormance under windows
2005-12-02 16:13 Re: Network permormance under windows Merlin Moncure <merlin.moncure@rcsonline.com>
@ 2005-12-02 17:24 ` Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>
2005-12-02 20:26 ` Re: Network permormance under windows me@alternize.com
2005-12-02 20:43 ` Re: Network permormance under windows Qingqing Zhou <zhouqq@cs.toronto.edu>
0 siblings, 2 replies; 6+ messages in thread
From: Josep Maria Pinyol Fontseca @ 2005-12-02 17:24 UTC (permalink / raw)
To: ; +Cc: pgsql-performance; info@teracat.com
Dear Merlin,
For instance, we have this table (with 22900 tuples):
CREATE TABLE tbl_empresa
(
id_empresa int4 NOT NULL DEFAULT nextval(('seq_empresa'::text)::regclass),
ref_poblacio int4 NOT NULL,
nom varchar(50) NOT NULL,
nif varchar(12),
carrer varchar(50),
telefon varchar(13),
fax varchar(13),
email varchar(50),
lab_materials int2 DEFAULT 0,
web varchar(50),
ref_empresa int4,
ref_classificacio_empresa int4,
ref_sector_empresa int4,
control int2,
origen_volcat int2,
data_modificacio date,
plantilla int4,
tamany int2,
autoritzacio_email int2,
ref_estat_empresa int2,
CONSTRAINT tbl_clients_pkey PRIMARY KEY (id_empresa),
CONSTRAINT fk_tbl_empresa_ref_classificacio_emp FOREIGN KEY
(ref_classificacio_empresa)
REFERENCES tbl_classificacio_empresa (id_classificacio_empresa) MATCH
SIMPLE
ON UPDATE RESTRICT ON DELETE RESTRICT,
CONSTRAINT fk_tbl_empresa_ref_empresa FOREIGN KEY (ref_empresa)
REFERENCES tbl_empresa (id_empresa) MATCH SIMPLE
ON UPDATE RESTRICT ON DELETE RESTRICT,
CONSTRAINT fk_tbl_empresa_ref_estat_emp FOREIGN KEY (ref_estat_empresa)
REFERENCES tbl_estat_empresa (id_estat_empresa) MATCH SIMPLE
ON UPDATE RESTRICT ON DELETE RESTRICT,
CONSTRAINT fk_tbl_empresa_ref_poblacio FOREIGN KEY (ref_poblacio)
REFERENCES tbl_poblacions (id_poblacio) MATCH SIMPLE
ON UPDATE RESTRICT ON DELETE RESTRICT,
CONSTRAINT fk_tbl_empresa_ref_sector_emp FOREIGN KEY (ref_sector_empresa)
REFERENCES tbl_sector_empresa (id_sector_empresa) MATCH SIMPLE
ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITH OIDS;
When we select all data in local machine, we obtain results in 2-3
seconds aprox. In remote connections:
Postgresql 7.1 usign pgAdminII:
Network traffic generated with remote applications is about 77-80% in a
10Mb connection.
6 seconds aprox.
Postgresql 8.1 usign pgAdminIII:
Network traffic generated with remote applications is about 2-4% in a
10Mb connection.
12 seconds or more...
I feel that is a problem with TCP_NODELAY of socket options... but I
don't know.
Josep Maria
En/na Merlin Moncure ha escrit:
>>We used Postgresql 7.1 under Linux and recently we have changed it to
>>Postgresql 8.1 under Windows XP. Our application uses ODBC and when we
>>try to get some information from the server throw a TCP connection,
>>
>>
>it's
>
>
>>very slow. We have also tried it using psql and pgAdmin III, and we
>>
>>
>get
>
>
>>the same results. If we try it locally, it runs much faster.
>>
>>We have been searching the mailing lists, we have found many people
>>
>>
>with
>
>
>>the same problem, but we haven't found any final solution.
>>
>>How can we solve this? Any help will be appreciated.
>>
>>Thanks in advance.
>>
>>
>>
>by any chance are you working with large tuples/columns (long text,
>bytea, etc)?
>
>Also please define slow.
>
>Merlin
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster
>
>
--
Josep Maria Pinyol i Fontseca
Responsable àrea de programació
ENDEPRO - Enginyeria de programari
Passeig Anselm Clavé, 19 Bx. 08263 Callús (Barcelona)
Tel. +34 936930018 - Mob. +34 600310755 - Fax. +34 938361994
jmpinyol@endepro.com - http://www.endepro.com
Aquest missatge i els documents en el seu cas adjunts,
es dirigeixen exclusivament al seu destinatari i poden contenir
informació reservada i/o CONFIDENCIAL, us del qual no està
autoritzat ni la divulgació del mateix, prohibit per la legislació
vigent (Llei 32/2002 SSI-CE). Si ha rebut aquest missatge per error,
li demanem que ens ho comuniqui immediatament per la mateixa via o
bé per telèfon (+34936930018) i procedeixi a la seva destrucció.
Aquest e-mail no podrà considerar-se SPAM.
Este mensaje, y los documentos en su caso anexos,
se dirigen exclusivamente a su destinatario y pueden contener
información reservada y/o CONFIDENCIAL cuyo uso no
autorizado o divulgación está prohibida por la legislación
vigente (Ley 32/2002 SSI-CE). Si ha recibido este mensaje por error,
le rogamos que nos lo comunique inmediatamente por esta misma vía o
por teléfono (+34936930018) y proceda a su destrucción.
Este e-mail no podrá considerarse SPAM.
This message and the enclosed documents are directed exclusively
to its receiver and can contain reserved and/or confidential
information, from which use isn’t allowed its divulgation, forbidden
by the current legislation (Law 32/2002 SSI-CE). If you have received
this message by mistake, we kindly ask you to communicate it to us
right away by the same way or by phone (+34936930018) and destruct it.
This e-mail can’t be considered as SPAM.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Network permormance under windows
2005-12-02 16:13 Re: Network permormance under windows Merlin Moncure <merlin.moncure@rcsonline.com>
2005-12-02 17:24 ` Re: Network permormance under windows Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>
@ 2005-12-02 20:26 ` me@alternize.com
1 sibling, 0 replies; 6+ messages in thread
From: me@alternize.com @ 2005-12-02 20:26 UTC (permalink / raw)
To: Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>; +Cc: pgsql-performance
we experienced the same. had 2 win2003 servers - www and db connected to the
same router through 100mbit. the performance was quite bad. now we run the
db on the same machine as the web and everything runs smooth.
cheers,
thomas
----- Original Message -----
From: "Josep Maria Pinyol Fontseca" <jmpinyol@endepro.com>
Cc: <pgsql-performance@postgresql.org>; <info@teracat.com>
Sent: Friday, December 02, 2005 6:24 PM
Subject: Re: [PERFORM] Network permormance under windows
>
> Dear Merlin,
>
> For instance, we have this table (with 22900 tuples):
>
> CREATE TABLE tbl_empresa
> (
> id_empresa int4 NOT NULL DEFAULT nextval(('seq_empresa'::text)::regclass),
> ref_poblacio int4 NOT NULL,
> nom varchar(50) NOT NULL,
> nif varchar(12),
> carrer varchar(50),
> telefon varchar(13),
> fax varchar(13),
> email varchar(50),
> lab_materials int2 DEFAULT 0,
> web varchar(50),
> ref_empresa int4,
> ref_classificacio_empresa int4,
> ref_sector_empresa int4,
> control int2,
> origen_volcat int2,
> data_modificacio date,
> plantilla int4,
> tamany int2,
> autoritzacio_email int2,
> ref_estat_empresa int2,
> CONSTRAINT tbl_clients_pkey PRIMARY KEY (id_empresa),
> CONSTRAINT fk_tbl_empresa_ref_classificacio_emp FOREIGN KEY
> (ref_classificacio_empresa)
> REFERENCES tbl_classificacio_empresa (id_classificacio_empresa) MATCH
> SIMPLE
> ON UPDATE RESTRICT ON DELETE RESTRICT,
> CONSTRAINT fk_tbl_empresa_ref_empresa FOREIGN KEY (ref_empresa)
> REFERENCES tbl_empresa (id_empresa) MATCH SIMPLE
> ON UPDATE RESTRICT ON DELETE RESTRICT,
> CONSTRAINT fk_tbl_empresa_ref_estat_emp FOREIGN KEY (ref_estat_empresa)
> REFERENCES tbl_estat_empresa (id_estat_empresa) MATCH SIMPLE
> ON UPDATE RESTRICT ON DELETE RESTRICT,
> CONSTRAINT fk_tbl_empresa_ref_poblacio FOREIGN KEY (ref_poblacio)
> REFERENCES tbl_poblacions (id_poblacio) MATCH SIMPLE
> ON UPDATE RESTRICT ON DELETE RESTRICT,
> CONSTRAINT fk_tbl_empresa_ref_sector_emp FOREIGN KEY (ref_sector_empresa)
> REFERENCES tbl_sector_empresa (id_sector_empresa) MATCH SIMPLE
> ON UPDATE RESTRICT ON DELETE RESTRICT
> )
> WITH OIDS;
>
> When we select all data in local machine, we obtain results in 2-3 seconds
> aprox. In remote connections:
>
> Postgresql 7.1 usign pgAdminII:
> Network traffic generated with remote applications is about 77-80% in a
> 10Mb connection.
> 6 seconds aprox.
>
> Postgresql 8.1 usign pgAdminIII:
> Network traffic generated with remote applications is about 2-4% in a 10Mb
> connection.
> 12 seconds or more...
>
> I feel that is a problem with TCP_NODELAY of socket options... but I don't
> know.
>
> Josep Maria
>
>
> En/na Merlin Moncure ha escrit:
>
>>>We used Postgresql 7.1 under Linux and recently we have changed it to
>>>Postgresql 8.1 under Windows XP. Our application uses ODBC and when we
>>>try to get some information from the server throw a TCP connection,
>>>
>>it's
>>
>>>very slow. We have also tried it using psql and pgAdmin III, and we
>>>
>>get
>>
>>>the same results. If we try it locally, it runs much faster.
>>>
>>>We have been searching the mailing lists, we have found many people
>>>
>>with
>>
>>>the same problem, but we haven't found any final solution.
>>>
>>>How can we solve this? Any help will be appreciated.
>>>
>>>Thanks in advance.
>>>
>>>
>>by any chance are you working with large tuples/columns (long text,
>>bytea, etc)?
>>
>>Also please define slow.
>>
>>Merlin
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: Don't 'kill -9' the postmaster
>>
>
>
> --
>
> Josep Maria Pinyol i Fontseca
> Responsable àrea de programació
>
> ENDEPRO - Enginyeria de programari
> Passeig Anselm Clavé, 19 Bx. 08263 Callús (Barcelona)
> Tel. +34 936930018 - Mob. +34 600310755 - Fax. +34 938361994
> jmpinyol@endepro.com - http://www.endepro.com
>
>
> Aquest missatge i els documents en el seu cas adjunts, es dirigeixen
> exclusivament al seu destinatari i poden contenir informació reservada i/o
> CONFIDENCIAL, us del qual no està autoritzat ni la divulgació del mateix,
> prohibit per la legislació vigent (Llei 32/2002 SSI-CE). Si ha rebut
> aquest missatge per error, li demanem que ens ho comuniqui immediatament
> per la mateixa via o bé per telèfon (+34936930018) i procedeixi a la seva
> destrucció. Aquest e-mail no podrà considerar-se SPAM.
>
> Este mensaje, y los documentos en su caso anexos, se dirigen
> exclusivamente a su destinatario y pueden contener información reservada
> y/o CONFIDENCIAL cuyo uso no autorizado o divulgación está prohibida por
> la legislación vigente (Ley 32/2002 SSI-CE). Si ha recibido este mensaje
> por error, le rogamos que nos lo comunique inmediatamente por esta misma
> vía o por teléfono (+34936930018) y proceda a su destrucción. Este e-mail
> no podrá considerarse SPAM.
>
> This message and the enclosed documents are directed exclusively to its
> receiver and can contain reserved and/or confidential information, from
> which use isn’t allowed its divulgation, forbidden by the current
> legislation (Law 32/2002 SSI-CE). If you have received this message by
> mistake, we kindly ask you to communicate it to us right away by the same
> way or by phone (+34936930018) and destruct it. This e-mail can’t be
> considered as SPAM.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Network permormance under windows
2005-12-02 16:13 Re: Network permormance under windows Merlin Moncure <merlin.moncure@rcsonline.com>
2005-12-02 17:24 ` Re: Network permormance under windows Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>
@ 2005-12-02 20:43 ` Qingqing Zhou <zhouqq@cs.toronto.edu>
2005-12-02 21:08 ` Re: Network permormance under windows Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>
1 sibling, 1 reply; 6+ messages in thread
From: Qingqing Zhou @ 2005-12-02 20:43 UTC (permalink / raw)
To: pgsql-performance
"Josep Maria Pinyol Fontseca" <jmpinyol@endepro.com> wrote
>
> When we select all data in local machine, we obtain results in 2-3 seconds
> aprox. In remote connections:
>
> Postgresql 7.1 usign pgAdminII:
> Network traffic generated with remote applications is about 77-80% in a
> 10Mb connection.
> 6 seconds aprox.
>
> Postgresql 8.1 usign pgAdminIII:
> Network traffic generated with remote applications is about 2-4% in a 10Mb
> connection.
> 12 seconds or more...
>
Have you tried to use psql? And how you "select all data" - by "select
count(*)" or "select *"?
Regards,
Qingqing
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Network permormance under windows
2005-12-02 16:13 Re: Network permormance under windows Merlin Moncure <merlin.moncure@rcsonline.com>
2005-12-02 17:24 ` Re: Network permormance under windows Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>
2005-12-02 20:43 ` Re: Network permormance under windows Qingqing Zhou <zhouqq@cs.toronto.edu>
@ 2005-12-02 21:08 ` Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>
0 siblings, 0 replies; 6+ messages in thread
From: Josep Maria Pinyol Fontseca @ 2005-12-02 21:08 UTC (permalink / raw)
To: Qingqing Zhou <zhouqq@cs.toronto.edu>; +Cc: pgsql-performance
Yes, with psql, pgAdminIII and our application with ODBC I experiment
the same situation... the sentences that I execute are like "select *
..." or similar like this.
Qingqing Zhou wrote:
>"Josep Maria Pinyol Fontseca" <jmpinyol@endepro.com> wrote
>
>
>>When we select all data in local machine, we obtain results in 2-3 seconds
>>aprox. In remote connections:
>>
>>Postgresql 7.1 usign pgAdminII:
>>Network traffic generated with remote applications is about 77-80% in a
>>10Mb connection.
>>6 seconds aprox.
>>
>>Postgresql 8.1 usign pgAdminIII:
>>Network traffic generated with remote applications is about 2-4% in a 10Mb
>>connection.
>>12 seconds or more...
>>
>>
>>
>
>Have you tried to use psql? And how you "select all data" - by "select
>count(*)" or "select *"?
>
>Regards,
>Qingqing
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster
>
>
--
Josep Maria Pinyol i Fontseca
Responsable àrea de programació
ENDEPRO - Enginyeria de programari
Passeig Anselm Clavé, 19 Bx. 08263 Callús (Barcelona)
Tel. +34 936930018 - Mob. +34 600310755 - Fax. +34 938361994
jmpinyol@endepro.com - http://www.endepro.com
Aquest missatge i els documents en el seu cas adjunts,
es dirigeixen exclusivament al seu destinatari i poden contenir
informació reservada i/o CONFIDENCIAL, us del qual no està
autoritzat ni la divulgació del mateix, prohibit per la legislació
vigent (Llei 32/2002 SSI-CE). Si ha rebut aquest missatge per error,
li demanem que ens ho comuniqui immediatament per la mateixa via o
bé per telèfon (+34936930018) i procedeixi a la seva destrucció.
Aquest e-mail no podrà considerar-se SPAM.
Este mensaje, y los documentos en su caso anexos,
se dirigen exclusivamente a su destinatario y pueden contener
información reservada y/o CONFIDENCIAL cuyo uso no
autorizado o divulgación está prohibida por la legislación
vigente (Ley 32/2002 SSI-CE). Si ha recibido este mensaje por error,
le rogamos que nos lo comunique inmediatamente por esta misma vía o
por teléfono (+34936930018) y proceda a su destrucción.
Este e-mail no podrá considerarse SPAM.
This message and the enclosed documents are directed exclusively
to its receiver and can contain reserved and/or confidential
information, from which use isn’t allowed its divulgation, forbidden
by the current legislation (Law 32/2002 SSI-CE). If you have received
this message by mistake, we kindly ask you to communicate it to us
right away by the same way or by phone (+34936930018) and destruct it.
This e-mail can’t be considered as SPAM.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2005-12-02 21:08 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-02 13:05 Network permormance under windows Teracat <info@teracat.com>
2005-12-02 16:13 Re: Network permormance under windows Merlin Moncure <merlin.moncure@rcsonline.com>
2005-12-02 17:24 ` Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>
2005-12-02 20:26 ` me@alternize.com
2005-12-02 20:43 ` Qingqing Zhou <zhouqq@cs.toronto.edu>
2005-12-02 21:08 ` Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox