X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D644D52925 for ; Thu, 16 Jun 2005 14:01:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95668-09 for ; Thu, 16 Jun 2005 17:01:04 +0000 (GMT) Received: from mir3-fs.mir3.com (www.mir3.com [216.74.11.46]) by svr1.postgresql.org (Postfix) with ESMTP id 83320528FE for ; Thu, 16 Jun 2005 14:01:01 -0300 (ADT) Received: from archimedes.mirlogic.com ([172.16.2.68]) by mir3-fs.mir3.com with Microsoft SMTPSVC(5.0.2195.6713); Thu, 16 Jun 2005 10:03:37 -0700 Subject: Re: Needed: Simplified guide to optimal memory From: Mark Lewis To: Todd Landfried Cc: pgsql-performance@postgresql.org In-Reply-To: <9A491A53-A5F5-4061-B1EA-8E4216299407@viatornetworks.com> References: <2608.1118845105@sss.pgh.pa.us> <9A491A53-A5F5-4061-B1EA-8E4216299407@viatornetworks.com> Content-Type: text/plain Organization: MIR3, Inc. Date: Thu, 16 Jun 2005 10:01:00 -0700 Message-Id: <1118941260.698.5.camel@archimedes.mirlogic.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-16) Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 16 Jun 2005 17:03:37.0171 (UTC) FILETIME=[56319230:01C57295] X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/336 X-Sequence-Number: 12973 We run the RPM's for RH 7.3 on our 7.2 install base with no problems. RPM's as recent as for PostgreSQL 7.4.2 are available here: ftp://ftp10.us.postgresql.org/pub/postgresql/binary/v7.4.2/redhat/redhat-7.3/ Or you can always compile from source. There isn't any such thing as a 'supported' package for RH7.2 anyway. -- Mark Lewis On Thu, 2005-06-16 at 07:46 -0700, Todd Landfried wrote: > Yes, it is 7.2. Why? because an older version of our software runs on > RH7.3 and that was the latest supported release of Postgresql for > RH7.3 (that we can find). We're currently ported to 8, but we still > have a large installed base with the other version. > > > On Jun 15, 2005, at 7:18 AM, Tom Lane wrote: > > > Dennis Bjorklund writes: > > > >> On Wed, 15 Jun 2005, Todd Landfried wrote: > >> > >>> NOTICE: shared_buffers is 256 > >>> > > > > > >> This looks like it's way too low. Try something like 2048. > >> > > > > It also is evidently PG 7.2 or before; SHOW's output hasn't looked > > like > > that in years. Try a more recent release --- there's usually > > nontrivial > > performance improvements in each major release. > > > > regards, tom lane > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to > > majordomo@postgresql.org) > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match