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

From Rohit Dewan
Subject Re: Size of database system
Date
Msg-id 002a01c1bef2$6d1ceda0$6d936b80@amer.cisco.com
Whole thread Raw
In response to Re: Size of database system  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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 by date:

Previous
From: Jeff Self
Date:
Subject: Re: Journaling file systems
Next
From: Felipe Carasso
Date:
Subject: Pl/PGSQL error