Received: from tincan.org ([216.64.180.202]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6AKCLa90922 for ; Tue, 10 Jul 2001 16:12:21 -0400 (EDT) (envelope-from raanders@tincan.org) Received: from localhost (raanders@localhost) by tincan.org (8.9.3/8.8.7) with ESMTP id NAA28703; Tue, 10 Jul 2001 13:12:05 -0700 Date: Tue, 10 Jul 2001 13:12:05 -0700 (PDT) From: "Roderick A. Anderson" To: Adam Manock cc: pgsql-general@postgresql.org Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU? In-Reply-To: <5.1.0.14.2.20010710072714.0234d120@pop.planetcable.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200107/330 X-Sequence-Number: 12251 On Tue, 10 Jul 2001, Adam Manock wrote: > Hi, > > I am about to put a 7.1.2 server into production on RedHat 7.1 > The server will be dedicated to PostgreSQL, running a bare minimum of > additional services. > If anyone has already tuned the configurable parameters on a dual PIII w/ > 1GB RAM then I > will have a great place to start for my performance tuning! > When I'm done I'll be posting my results here for the next first timer that > comes along. I've just did a quick read of Bruce's article in Linux Journal. My take is this is more than a hardware issue. Table size, indexes (indices?) verses sequential scans will come into play. I don't think you can even really test without some relevant data, queries, etc. Again this was a very quick read of the article. Thanks Bruce. It looks enlightening. Cheers, Rod -- Remove the word 'try' from your vocabulary ... Don't try. Do it or don't do it ... Steers try! Don Aslett