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 :-) )
Дата
Msg-id dcc563d10809151452j12e360c6j98fac361b98f517e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )  ("Martin Langhoff" <martin.langhoff@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Martin Langhoff"
Дата:
Сообщение: Re: Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Out of memory on SELECT (from sort?) in 8.3