Re: [ADMIN] Limiting size and number of transaction logs

2005-01-14 Thread Chris White (cjwhite)
Thanks for the information. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 5:36 PM To: [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Limiting size and number of transaction logs "Chris White (cjwhite)&quo

Re: [ADMIN] Limiting size and number of transaction logs

2005-01-14 Thread Tom Lane
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes: > In the documentation for 7.4 for WAL configuration, I see the following > statement: > There will be at least one 16 MB segment file, and will normally not be more > than 2 * checkpoint_segments + 1 files. > So if I have 1 checkpoint segment

[ADMIN] Limiting size and number of transaction logs

2005-01-14 Thread Chris White (cjwhite)
In the documentation for 7.4 for WAL configuration, I see the following statement:   There will be at least one 16 MB segment file, and will normally not be more than 2 * checkpoint_segments + 1 files.   So if I have 1 checkpoint segment configured, does this mean there will be a max of 4