Pam Wampler <Pam_Wampler(at)taylorwhite(dot)com> writes:
> 1. what parameter tells postgress to always keep 7 files in the pg_xlog
> directory? (see below) --this is test database we
> are learning on. (and it seems everytime that I look at this directory there
> are always 7 entries there)
It's basically 2 * checkpoint_segments + 1. See
> 2. What happens when the files increment and can no longer increment to a
> higher number (the file name)?
Trouble, which is why we use a 64-bit counter.
> 3. Is there a way to "reset" the number so that this won't happen?
initdb. However, you're not gonna have to worry about it in your
lifetime. Do the math...
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Henshall, Stuart - WCP||Date: 2002-07-12 15:32:47|
|Subject: Re: Newbie Stupid Question|
|Previous:||From: Al Arduengo||Date: 2002-07-12 14:33:30|
|Subject: removing specific duplicates|