Re: Performance problem on RH7.1

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(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
> Sent: 2004. június 26. 17:10
> To: csegyud(at)vnet(dot)hu
> Cc: Pgsql-General(at)Postgresql(dot)Org (E-mail)
> Subject: Re: [GENERAL] Performance problem on RH7.1
>
>
> =?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud(at)vnet(dot)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(at)postgresql(dot)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.