Re: Postgres low end processing.

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: Stef <svb(at)ucs(dot)co(dot)za>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres low end processing.
Date: 2003-10-06 06:11:34
Message-ID: 3F810796.8010403@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Stef wrote:

> On Fri, 03 Oct 2003 12:32:00 -0400
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-10-06 06:43:33 Re: Server recommendations
Previous Message Nagib Abi Fadel 2003-10-06 05:35:10 databse design tutorial

Browse pgsql-performance by date

  From Date Subject
Next Message Stef 2003-10-06 07:55:51 Re: Postgres low end processing.
Previous Message Shridhar Daithankar 2003-10-06 06:06:36 Re: count(*) slow on large tables