Обсуждение: Size of database system

Поиск
Список
Период
Сортировка

Size of database system

От
"Rohit Dewan"
Дата:
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?
2. Is there a way I can customize a template file of some kind to
produce a much smaller database system?

Thanks,
Rohit

Re: Size of database system

От
Stephan Szabo
Дата:
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.

Re: Size of database system

От
"Rohit Dewan"
Дата:
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.