Re: disable archiving - Mailing list pgsql-performance

From Paul van den Bogaard
Subject Re: disable archiving
Date
Msg-id BD28A71D-6AB4-4BD8-9458-AEEDE94F3120@Sun.COM
Whole thread Raw
In response to Re: disable archiving  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-performance
Alvaro,

thanks for the quick reply. Just to make sure: I do not set this
command. This results in the database cycling through a finite set
(hopefully small) set of WAL files. So old WAL files are reused once
the engine thinks this can be done.

Thanks
Paul


On 23-jul-2007, at 19:34, Alvaro Herrera wrote:

> Paul van den Bogaard wrote:
>> the manual somewhere states "... if archiving is enabled..." To me
>> this
>> implies that archiving can be disabled. However I cannot find the
>> parameter
>> to use to get this result.
>
> Archiving is disabled by not setting archive_command.
>
> --
> Alvaro Herrera                                http://
> www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.

------------------------------------------------------------------------
---------------------
Paul van den Bogaard
Paul.vandenBogaard@sun.com
CIE -- Collaboration and ISV Engineering, Opensource Engineering group

Sun Microsystems, Inc                              phone:        +31
334 515 918
Saturnus 1
extentsion: x (70)15918
3824 ME Amersfoort                                 mobile:       +31
651 913 354
The Netherlands
fax:            +31 334 515 001


pgsql-performance by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: disable archiving
Next
From: "Simon Riggs"
Date:
Subject: Re: User concurrency thresholding: where do I look?