Size of database system
Size of database system
От:
"Rohit Dewan" <rdewan@cisco.com>
Дата:
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 <sszabo@megazone23.bigpanda.com>
Дата:
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" <rdewan@cisco.com>
Дата:
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.