From: Ron Johnson <ron.l.johnson@cox.net>
To: PgSQL General ML <pgsql-general@postgresql.org>
Subject: Re: [PERFORM] Postgres low end processing.
Date: Fri, 03 Oct 2003 15:42:32 -0500
Message-ID: <1065213752.1487.144.camel@haggis> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: ron.l.johnson@cox.net, pgsql-general@postgresql.org
Subject: Re: [PERFORM] Postgres low end processing.
In-Reply-To: <1065213752.1487.144.camel@haggis>
References: <20031003163040.3641f39a.svb@ucs.co.za> <200310031108.49002.josh@agliodbs.com> <1065207892.391.36.camel@tokyo> <1065213752.1487.144.camel@haggis>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox