Re: [ADMIN] xid wraparound

2010-09-25 Thread Tom Lane
Mark Rostron writes: > When the XID wraps, at the moment it does so, unless you set > vacuum_freeze_min_age to 0 and a vacuum has just been performed, is > there not a chance that there will be some data loss? No. XID comparisons are modulo 2^31. regards, tom lane -- S

[ADMIN] xid wraparound

2010-09-25 Thread Mark Rostron
When the XID wraps, at the moment it does so, unless you set vacuum_freeze_min_age to 0 and a vacuum has just been performed, is there not a chance that there will be some data loss? If it changes value from (2^32 -1) to (0), it's value is going to be less than SOME rows - the ones which have no

Re: [ADMIN] [pgsql-admin] Daily digest v1.3327 (2 messages)

2010-09-25 Thread Justin Pitts
> -- Forwarded message -- >> So, you have everything running and working in aprox. 10 seconds. > > All of the Windows Server stuff via Microsoft Cluster Services I'm aware of > does its shared storage node fencing via sending specific SCSI calls > (PERSISTENT RESERVE) to the >stor