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" <[EMAIL PROTECTED]> wrote
When we select all data in local machine, w
"Josep Maria Pinyol Fontseca" <[EMAIL PROTECTED]> 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.
inyol Fontseca" <[EMAIL PROTECTED]>
Cc: ; <[EMAIL PROTECTED]>
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 NO
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
> 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
