Re: Poor performance
От | Henshall, Stuart - WCP |
---|---|
Тема | Re: Poor performance |
Дата | |
Msg-id | E2870D8CE1CCD311BAF50008C71EDE8E01F747F8@MAIL_EXCHANGE обсуждение исходный текст |
Ответ на | Poor performance (BELLON Michel <Michel.Bellon@lcie.fr>) |
Список | 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 по дате отправления: