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

Поиск
Список
Период
Сортировка
От Martin Langhoff
Тема Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )
Дата
Msg-id 46a038f90809151446q6834c55foa3be3206c5bc9847@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )  (Robert Treat <xzilla@users.sourceforge.net>)
Ответы Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
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)

> 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@gmail.com
 martin@laptop.org -- School Server Architect
 - ask interesting questions
 - don't get distracted with shiny stuff - working code first
 - http://wiki.laptop.org/go/User:Martinlanghoff

В списке pgsql-general по дате отправления:

Предыдущее
От: "Martin Langhoff"
Дата:
Сообщение: Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )