Search Postgresql Archives

Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Sep 16, 2008 at 8:36 AM, Robert Treat
<xzilla@xxxxxxxxxxxxxxxxxxxxx> 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)

> Also, if your disk is limited, you might want to play with the
> autovacuum_max_freeze_age and the corresponding vacuum settings to try and
> reduce pg_clog size.

Intriguing. I'll look into those.

thanks!


m
-- 
 martin.langhoff@xxxxxxxxx
 martin@xxxxxxxxxx -- School Server Architect
 - ask interesting questions
 - don't get distracted with shiny stuff - working code first
 - http://wiki.laptop.org/go/User:Martinlanghoff


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux