RE: Re: Strangeness in xid allocation / snapshot setup - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: Re: Strangeness in xid allocation / snapshot setup
Date
Msg-id 3705826352029646A3E91C53F7189E320166CA@sectorbase2.sectorbase.com
Whole thread Raw
In response to Strangeness in xid allocation / snapshot setup  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > Isn't spinlock just a few ASM instructions?... on most platforms...
> 
> If we change over to something that supports read vs write locking,
> it's probably going to be rather more than that ... right now, I'm
> pretty dissatisfied with the performance of our spinlocks under load.

We shouldn't use light locks everywhere. Updating/reading MyProc.xid
is very good place to use simple spinlocks... or even better mutexes.

Vadim


pgsql-hackers by date:

Previous
From: "P. Dwayne Miller"
Date:
Subject: select count...
Next
From: Tom Lane
Date:
Subject: Re: Re: Strangeness in xid allocation / snapshot setup