Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) ) - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )
Date
Msg-id dcc563d10809151452j12e360c6j98fac361b98f517e@mail.gmail.com
Whole thread Raw
In response to Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )  ("Martin Langhoff" <martin.langhoff@gmail.com>)
List pgsql-general
On Mon, Sep 15, 2008 at 3:46 PM, Martin Langhoff
<martin.langhoff@gmail.com> wrote:
> On Tue, Sep 16, 2008 at 8:36 AM, Robert Treat
> <xzilla@users.sourceforge.net> wrote:
>> Call me crazy, but I think you need to drop postgres and maybe even template0
>> databases from the system, just to reduce overall footprint, plus gives you
>> less databases to have to keep track of wrt autovacuum and such.
>
> What would be the impact of running w/o postgres and template0? They
> seem to take 13MB on a freshly init'd Pg -- I can afford to have them
> there if needed. In general, I am not expecting to be super-tight on
> disk... (not yet at least)

template0 is the database used in case of emergency to restore
template1 should you do something stupid.  Generally it's never used.

postgres is the database that all the command line utils (createdb,
vacuumdb, etc) all use to connect to.

pgsql-general by date:

Previous
From: "Martin Langhoff"
Date:
Subject: Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )
Next
From: Tom Lane
Date:
Subject: Re: Out of memory on SELECT (from sort?) in 8.3