Received: from charon.simplot.com (jrsmailhub.simplot.com [12.18.144.212]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA7NtEm30306 for ; Wed, 7 Nov 2001 18:55:14 -0500 (EST) (envelope-from earlj@xanadu.simplot.com) Received: from xanadu.simplot.COM (151.113.0.132) by charon.simplot.com (MX V5.1-A AnGp) with SMTP; Wed, 7 Nov 2001 16:55:15 -0700 Received: from npa01zz001.simplot.com by xanadu.simplot.COM; (5.65v4.0/1.1.8.2/20Aug97-1116AM) id AA20032; Wed, 7 Nov 2001 16:55:15 -0700 Received: from earlj by npa01zz001.simplot.com with local (Exim 3.32 #1 (Debian)) id 161cXK-0000kl-00; Wed, 07 Nov 2001 16:55:14 -0700 To: Francisco Reyes CC: Keary Suska , PostgreSQL Subject: Re: performance tuning References: <20011107180801.E27009-100000@zoraida.natserv.net> From: Jason Earl Date: 07 Nov 2001 16:55:14 -0700 In-Reply-To: <20011107180801.E27009-100000@zoraida.natserv.net> Message-ID: <87lmhit9ul.fsf@npa01zz001.simplot.com> Lines: 39 User-Agent: Gnus/5.0808 (Gnus v5.8.8) Emacs/21.1 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/310 X-Sequence-Number: 17306 Bruce Momjian says it much better than I could: http://www.ca.postgresql.org/docs/momjian/hw_performance/ You also might take a look at some of your most resource draining queries with 'explain' in psql. Jason Earl Francisco Reyes writes: > On Sat, 27 Oct 2001, Keary Suska wrote: > > > If I had a guess I would say the problem isn't with postgres, if your system > > CPU usage is 50%. I haven't had a system go over 20%, even under extreme > > duress. Are you by chance using Linux with a 2.4 kernel? The swap mechanism > > in 2.4 was terrible (it may have been fixed by now). What is you memory and > > virtual memory performance like? Extensive swapping could be at least > > partially responsible. > > > > Keary Suska > > Esoteritech, Inc. > > "Leveraging Open Source for a better Internet" > > coming very late to this thread.. > In general what settings can one change to enhance performance. I too have > a machine with high CPU utilization when doing a query. Said query does a > sequential scan. > > When I use 'top' to see how much memory is been used by postgresql it is > only using 8MB. This machine is very lightly used so I would like to give > PostgreSQL more memory. > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html