pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (17+ messages)  latest in thread

Message-ID: <3F810796.8010403@persistent.co.in>
Permalink:  ../3F810796.8010403@persistent.co.in/
Also on:    postgresql.org/message-id/3F810796.8010403@persistent.co.in

 · 

reply

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