Re: archive_timeout - good indication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Renato Oliveira <renato.oliveira@xxxxxxxxxxx> wrote:
 
> What would be a good indication for  'archive_timeout' on a busy
> server?
 
The maximum amount of time for which you can tolerate lost
transactions in case you need to use the backup for crash recovery. 
Note that you need to balance that need against the space
requirements of the WAL files.  You can mitigate the space problem
by using pg_clearxlogtail or pglesslog.
 
-Kevin

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux