Re: Size of database system

Поиск
Список
Период
Сортировка
От Rohit Dewan
Тема Re: Size of database system
Дата
Msg-id 002a01c1bef2$6d1ceda0$6d936b80@amer.cisco.com
обсуждение исходный текст
Ответ на Re: Size of database system  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-admin
Hi Stephan,

Thanks for your reply!

So now, how do you go about changing the xlog segment size?

Regards,
Rohit

-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com]
Sent: Tuesday, February 26, 2002 10:03 AM
To: Rohit Dewan
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Size of database system


On Tue, 26 Feb 2002, Rohit Dewan wrote:

> Hi All,
>
> Creating a database system using initdb generates about 20MB of data
in
> the data folder. I have 2 questions:
>
> 1. Why is it so large?

My guess would be the 16 meg transaction log segment.

> 2. Is there a way I can customize a template file of some kind to
> produce a much smaller database system?

I'm not sure there'd be much you could do apart from changing the
xlog segment size, but I don't know if that's safe.



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

Предыдущее
От: Jeff Self
Дата:
Сообщение: Re: Journaling file systems
Следующее
От: Felipe Carasso
Дата:
Сообщение: Pl/PGSQL error