Re: Size of database system - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Size of database system
Date
Msg-id 20020226094926.P90836-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Size of database system  ("Rohit Dewan" <rdewan@cisco.com>)
Responses Re: Size of database system  ("Rohit Dewan" <rdewan@cisco.com>)
List pgsql-admin
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 by date:

Previous
From: Ragnar Kjørstad
Date:
Subject: Re: Journaling file systems
Next
From: Jeff Self
Date:
Subject: Re: Journaling file systems