[COMMITTERS] contrib/earthdistance README.earthdistance

2003-12-27 Thread Tom Lane 
CVSROOT:/cvsroot
Module name:contrib
Changes by: [EMAIL PROTECTED]   03/12/27 14:20:18

Modified files:
earthdistance  : README.earthdistance 

Log message:
Remove incorrect remark about having to restart backend to load a new
version of a shared library.


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[COMMITTERS] pgsql-server/src backend/storage/lmgr/s_lock.c ...

2003-12-27 Thread Tom Lane 
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/12/27 16:58:58

Modified files:
src/backend/storage/lmgr: s_lock.c 
src/include/storage: s_lock.h 

Log message:
Improve spinlock code for recent x86 processors: insert a PAUSE
instruction in the s_lock() wait loop, and use test before test-and-set
in TAS() macro to avoid unnecessary bus traffic.  Patch from Manfred
Spraul, reworked a bit by Tom.


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match