> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: 13 September 2005 23:03 > To: Marko Kreen > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Spinlocks, yet again: analysis and > proposed patches > > I'm starting to think that we might have to succumb to having > a compile > option "optimize for multiprocessor" or "optimize for single > processor". > It's pretty hard to see how we'd alter a data structure decision like > this on the fly.
That would be a major pita for packagers of binary distributions. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match