[PERFORM] Windows performance again

2005-12-21 Thread Josep Maria Pinyol Fontseca
Hello, We have the next scenario: Linux box with postgresql 7.2.1-1 (client) Windows XP with postgresql 8.1.1 (server) Windows XP with postgresql 8.1.1 (client) All connected in 10Mb LAN In server box, we have a table with 65000 rows and usign "psql" we have these results: Linux box with ps

Re: [PERFORM] Network permormance under windows

2005-12-02 Thread Josep Maria Pinyol Fontseca
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

Re: [PERFORM] Network permormance under windows

2005-12-02 Thread Josep Maria Pinyol Fontseca
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