Re: Size of database system

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(at)megazone23(dot)bigpanda(dot)com]
Sent: Tuesday, February 26, 2002 10:03 AM
To: Rohit Dewan
Cc: pgsql-admin(at)postgresql(dot)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.