Re: Poor performance

With sort mem being applied per backend it might be that the high memory
usage is taking the memory above its cygwin limit. I *think* this is as
default 256MB now, however I beliave setting heap_chunk_in_mb might help.
However I have never done this myself. I'd suggest having a look through the
cygwin archives.
Sorry I couldn't be more help,
- Stuart

> -----Original Message-----
> From: BELLON Michel [mailto:Michel(dot)Bellon(at)lcie(dot)fr]
> Sent: 21 February 2002 17:07
> To: Henshall, Stuart - WCP
> Subject: RE: [CYGWIN] Poor performance
>
>
> thanks a lot, CPU is now quite "normal", approximately >80%
> but at present, I get with
>
> pgbench pgbench -c 80
>
> and max_connections = 200 !!!
>
> /usr/bin/postmaster: BackendStartup: pid 2640 user bellon db
> pgbench socket
> 8
> FindExec: found "/usr/bin/postgres" using argv[0]
> 2002-02-21 16:50:10 [2640] DEBUG: connection: host=172.16.2.23
> user=bellon database=pgbench
> 2002-02-21 16:50:10 [2640] DEBUG: StartTransactionCommand
> 2002-02-21 16:50:10 [2640] DEBUG: query: select
> getdatabaseencoding()
> 2002-02-21 16:50:10 [2640] DEBUG: CommitTransactionCommand
> /usr/bin/postmaster: BackendStartup: pid 2464 user bellon db
> pgbench socket
> 8
> FindExec: found "/usr/bin/postgres" using argv[0]
> 2002-02-21 16:50:10 [2464] DEBUG: connection: host=172.16.2.23
> user=bellon database=pgbench
> 2002-02-21 16:50:10 [2464] DEBUG: StartTransactionCommand
> 2002-02-21 16:50:10 [2464] DEBUG: query: select
> getdatabaseencoding()
> 2002-02-21 16:50:10 [2464] DEBUG: CommitTransactionCommand
> /usr/bin/postmaster: BackendStartup: fork failed: Resource temporarily
> unavailable
> Backend startup failed
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
>
> I increased shared buffers to 30000, I was unable to do more
> and to start
> Postgresql
> (sort_mem=3072)
>
> the max memory for postgres.exe is 249 944 kbytes in this
> case and each
> backend use about 10 Mbytes
>
> Best regards
>
> Michel BELLON
> LCIE - Méthodes/Informatique appliquée
> 33 (0)1 40 95 60 35
> http://www.lcie.fr
>
> > -----Message d'origine-----
> > De: Henshall, Stuart - WCP
> > [SMTP:SHenshall(at)westcountrypublications(dot)co(dot)uk]
> > Date: jeudi 21 février 2002 12:19
> > À: 'BELLON Michel'; pgsql-cygwin(at)postgresql(dot)org
> > Objet: RE: [CYGWIN] 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
> > >
> > >
>