Re: Poor performance

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(dot)Bellon(at)lcie(dot)fr]
> Sent: 21 February 2002 10:48
> To: pgsql-cygwin(at)postgresql(dot)org; Jason(dot)Tishler(at)dothill(dot)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
>
>