Re: Poor performance - Mailing list pgsql-cygwin

From Henshall, Stuart - WCP
Subject Re: Poor performance
Date
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E01F747F8@MAIL_EXCHANGE
Whole thread Raw
In response to Poor performance  (BELLON Michel <Michel.Bellon@lcie.fr>)
List pgsql-cygwin
I'm not sure about the errors, it may be cygwin rather than PostgreSQL.
Maybe try the latest snapshot see if that helps.
Otherwise perhaps report to pgsql-bugs.
This first thing that leaps out at me for performance is:
#sort_mem = 512
shared_buffers = 200 # 2*max_connections # min 16
Try putting shared_buffers higher (maybe 24000).
To use larger values be aware of:
http://sources.redhat.com/ml/cygwin/2000-04/msg00267.html
Maybe increase sort mem to a couple of thousand as well.
See the docs for more info.
Also PostgreSQL 7.2 is now out & may be worth a spin.
Hope this helps,
- Stuart

> -----Original Message-----
> From: BELLON Michel [mailto:Michel.Bellon@lcie.fr]
> Sent: 21 February 2002 10:48
> To: pgsql-cygwin@postgresql.org; Jason.Tishler@dothill.com; Dave Page
> Subject: [CYGWIN] Poor performance
>
>
> Hi all
>
> I'am trying to configure PostgreSQL 7.1.3-2 with cygwin on a
> Win 2000 box
> (Compaq Proliant ML370, Bi PIII 1GHz, 1 Go RAM)
>
> For testing, I use pgbench and I obtain very poor results. Very often,
> PosgreSQL hang for about 10 clients.
> The CPU use is very low (~< 5 %)
>
> The version are
>     crypt 1.0.1
>     cygipc 1.11-1
>     readline 4.4- or 4.2 ??
>     zlib 1.1.3-7
>     cygwin 1.3.9-1
>
> Here are the configuration file and log
>
>
>  <<debug.txt>>  <<postgresql.conf>>
> Any help would be greatly appreciated
>
> Regards
>
>
> Michel BELLON
> LCIE - Méthodes/Informatique appliquée
> 33 (0)1 40 95 60 35
> http://www.lcie.fr
>
>

pgsql-cygwin by date:

Previous
From: BELLON Michel
Date:
Subject: Poor performance
Next
From: Kannan
Date:
Subject: "psql" gives error.