But would it be a problem to have only 1 active segment at all times ?
My inspiration pretty much comes from Oracle, where redo logs are
pre-configured and can be switched by a command issued to the instance.
> Just because you'd like that to be true doesn't make it true. We have
> to manage a variable number of active segments; track whether a given
> segment is waiting for future use, active, waiting to be archived, etc;
> manage status signaling to the archiver process; and so on. Now I'll
> freely admit that using a filesystem is only one of the ways that those
> problems could be attacked, but that's how they've been attacked in
> Postgres. If you want to not have that functionality present then
> you'd need to rewrite all that code and provide some other
> infrastructure for it to use.
> regards, tom lane
In response to
pgsql-general by date
|Next:||From: Alvaro Herrera||Date: 2007-09-01 00:23:39|
|Subject: Re: WAL to RAW devices ?|
|Previous:||From: Tom Lane||Date: 2007-09-01 00:08:10|
|Subject: Re: WAL to RAW devices ? |