Simon Riggs пишет:
> On Tue, 2008-07-08 at 13:09 +0500, Dmitry Melekhov wrote:
>
>> Hello!
>>
>> I tried to ask this question in novice list.
>> Just because there are no replies I try here.
>> This is really novice question- I'm oracle dba :-)
>>
>>
>>> I just installed 8.3 with WAL enabled.
>>> But I can't understand why postgres generated many archive logs during
>>> vacuum, if WAL is enabled.
>>> Could you explain?
>>>
>
> What do you mean "WAL is enabled"? That's not a term I recognize since
> WAL is always enabled.
>
>
AFAIK, it can be disabled. May be I'm wrong...
> Best read this
> http://developer.postgresql.org/pgdocs/postgres/routine-vacuuming.html
>
> VACUUM needs to perform writes to clear up, which generates WAL.
>
>
This is what I don't understand.
I think WAL can be used for point-in-time recovery.
So, if I have database backup and WAL generated after this backup, I can
do recovery, this mean WAL already contains all changes to database,
without vacuum. Could you tell me what is wrong in my sentence?