From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: Stef <svb@ucs.co.za>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres low end processing.
Date: Mon, 06 Oct 2003 11:41:34 +0530
Message-ID: <3F810796.8010403@persistent.co.in> (raw)
In-Reply-To: <20031003195238.16fc1229.svb@ucs.co.za>
References: <20031003163040.3641f39a.svb@ucs.co.za>
<24646.1065195774@sss.pgh.pa.us>
<20031003181002.20cc6912.svb@ucs.co.za>
<26554.1065198720@sss.pgh.pa.us>
<20031003195238.16fc1229.svb@ucs.co.za>
Stef wrote:
> On Fri, 03 Oct 2003 12:32:00 -0400
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> => What exactly is failing? And what's the platform, anyway?
>
> Nothing is really failing atm, except the funds for better
> hardware. JBOSS and some other servers need to be
> run on these machines, along with linux, which will be
> a minimal RH >= 7.2 with kernel 2.4.21
> (Any better suggestions here?)
>
> In this case, whatever is the least amount of memory
> postgres can run on, is what is needed. So this is still
> a kind of feasibility study. Of course, it will still be thoroughly
> tested, if it turns out to be possible. (Which I know it is, but not how)
If you mean to say that postgresql should use just 8 MB of RAM rather than
running it on a 8MB machine, then that is impossible given how much postgresql
relies upon OS cache.
You may configure postgresql with 8MB shared memory or the old holy default of
512K, but if your database is 100MB and OS is caching half of it on behalf of
postgresql, your goal is already missed..
Shridhar
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: shridhar_daithankar@persistent.co.in, svb@ucs.co.za, tgl@sss.pgh.pa.us
Subject: Re: Postgres low end processing.
In-Reply-To: <3F810796.8010403@persistent.co.in>
* 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