X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id DC4AFD1B55E for ; Fri, 3 Oct 2003 20:51:40 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 40018-10 for ; Fri, 3 Oct 2003 17:50:53 -0300 (ADT) Received: from lakemtao03.cox.net (lakemtao03.cox.net [68.1.17.242]) by svr1.postgresql.org (Postfix) with ESMTP id 89394D1B533 for ; Fri, 3 Oct 2003 17:42:31 -0300 (ADT) Received: from lhosts ([68.11.66.83]) by lakemtao03.cox.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20031003204234.MCKL17519.lakemtao03.cox.net@lhosts> for ; Fri, 3 Oct 2003 16:42:34 -0400 Subject: Re: [PERFORM] Postgres low end processing. From: Ron Johnson To: PgSQL General ML In-Reply-To: <1065207892.391.36.camel@tokyo> References: <20031003163040.3641f39a.svb@ucs.co.za> <200310031108.49002.josh@agliodbs.com> <1065207892.391.36.camel@tokyo> Content-Type: text/plain Message-Id: <1065213752.1487.144.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Fri, 03 Oct 2003 15:42:32 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/169 X-Sequence-Number: 50242 On Fri, 2003-10-03 at 14:04, Neil Conway wrote: > On Fri, 2003-10-03 at 14:08, Josh Berkus wrote: > > I can tell you from experience that you will get some odd behaviour, and even > > connection failures, when Postgres is forced into swap by lack of memory. > > Why would you get a connection failure? And other than poor performance, > why would you get "odd behavior" due to a lack of physical memory? It would take so long for the "server" to respond that the client might time out. Of course, back in the day, we supported 70 people on a mainframe w/ 1.6 MIPS and 8MB RAM. FEPs and 3270 terminals helped, of course. -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA "All machines, no matter how complex, are considered to be based on 6 simple elements: the lever, the pulley, the wheel and axle, the screw, the wedge and the inclined plane." Marilyn Vos Savant