[Server-devel] [GENERAL] Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )

[Scott Marlowe]

On Mon, Sep 15, 2008 at 3:46 PM, Martin Langhoff
<martin.langhoff at gmail.com> wrote:
> On Tue, Sep 16, 2008 at 8:36 AM, Robert Treat
> <xzilla at 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.