Re: Performance problem on RH7.1
От | Együd Csaba |
---|---|
Тема | Re: Performance problem on RH7.1 |
Дата | |
Msg-id | 015901c45ba0$7944bf20$230a0a0a@compaq обсуждение исходный текст |
Ответ на | Re: Performance problem on RH7.1 (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
Hi Tom, Thank you for your reply. No, I do not. On the production server I have higher values for sort_mem (32768) and shared_buffers (2048). The other settings are the same. bye, -- Csaba Együd > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tom Lane > Sent: 2004. június 26. 17:10 > To: csegyud@vnet.hu > Cc: Pgsql-General@Postgresql.Org (E-mail) > Subject: Re: [GENERAL] Performance problem on RH7.1 > > > =?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud@vnet.hu> writes: > > I've a problem with the perfprmance of the production environment. > > I've two db servers. One on my laptop computer (2Ghz, 1GB, > WinXP, Cygwin, > > Postgres 7.3.4) and one on a production server (2GHz, 1GB, > Ultra SCSI, > > RH7.1, Postgres 7.3.2). > > Are you using the same postgresql.conf settings on both? > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so > that your > message can get through to the mailing list cleanly > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.707 / Virus Database: 463 - Release Date: 2004. 06. 15. > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.707 / Virus Database: 463 - Release Date: 2004. 06. 15.
В списке pgsql-general по дате отправления: