Re: 9.0.15 WAL mis-replay status?

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

 



Ray Stell <stellr@xxxxxx> writes:
> I finally got permission to patch a highly used db from 9.0.15 to .17.  Is there any way to know if the WAL replay issue has effected the standby?  I don't have the reported bloat, is that THE test?  Is there any way to measure the current state of this issue listed in the 9.0.16 release notes:
> Fix possible mis-replay of WAL records when some segments of a relation aren't full size (Greg Stark, Tom Lane)

TBH, I'd suggest re-syncing the standby after you upgrade.  Obvious bloat
is one symptom, but only one symptom.

Note however that the issue could only arise on tables that exceed 1GB, so
depending on your usage, maybe you don't have a problem.

			regards, tom lane


-- 
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