Re: [GENERAL] please explain vacuum with WAL

2008-07-08 Thread Dmitry Melekhov
Simon Riggs пишет: > Vacuum performs an essential function and its changes are WAL-logged. > Those changes are an essential part of the structure of the database and > must be included as part of recovery also. > Now I understand. Thank you! -- Sent via pgsql-general mailing list (pgsql-gene

Re: [GENERAL] please explain vacuum with WAL

2008-07-08 Thread Dmitry Melekhov
WAL ? As I understand all database changes are already logged > - Original Message ---- > >> From: Dmitry Melekhov <[EMAIL PROTECTED]> >> To: Simon Riggs <[EMAIL PROTECTED]> >> Cc: pgsql-general@postgresql.org >> Sent: Tuesday, 8 July, 2008 9:54

Re: [GENERAL] please explain vacuum with WAL

2008-07-08 Thread Dmitry Melekhov
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 :-) >

[GENERAL] please explain vacuum with WAL

2008-07-08 Thread Dmitry Melekhov
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. > Cou