Re: [HACKERS] optimizing repeated MVCC snapshots

2012-01-05 Thread Robert Haas
On Thu, Jan 5, 2012 at 9:01 AM, Florian Weimer wrote: > * Robert Haas: >> and (c) architectures (like 32-bit x86) where ordinary 64-bit >> operations aren't atomic but special instructions (cmpxchg8b) can be >> used to get that behavior. > > FILD and FIST are atomic, too, and are supported by more

Re: [HACKERS] optimizing repeated MVCC snapshots

2012-01-05 Thread Florian Weimer
* Robert Haas: > and (c) architectures (like 32-bit x86) where ordinary 64-bit > operations aren't atomic but special instructions (cmpxchg8b) can be > used to get that behavior. FILD and FIST are atomic, too, and are supported by more micro-architectures. -- Florian Weimer BFK

[HACKERS] optimizing repeated MVCC snapshots

2012-01-05 Thread Robert Haas
On Tue, Jan 3, 2012 at 2:22 PM, Tom Lane wrote: >> Another thought is that it should always be safe to reuse an old >> snapshot if no transactions have committed or aborted since it was >> taken > > Yeah, that might work better.  And it'd be a win for all MVCC snaps, > not just the ones coming fro