Re: [PATCHES] sinval contention reduction

2008-01-26 Thread Simon Riggs
On Fri, 2008-01-25 at 19:02 -0500, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: Patch to reduce the contention on SInvalLock, as discussed here: http://archives.postgresql.org/pgsql-hackers/2007-09/msg00501.php and

[PATCHES] WIP: variadic function, named params

2008-01-26 Thread Pavel Stehule
Hello, there is one implementation of variadic functions. The base premis is transformation type: anyparams - n x any anyelements - n x anyelement Currently variadic functions can be only in C language. PL/pgSQL cannot access to array of params. I implented some JSON functions (based on

Re: [PATCHES] sinval contention reduction

2008-01-26 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: On Fri, 2008-01-25 at 19:02 -0500, Tom Lane wrote: This seems large, complex, and untested (I note in particular a guaranteed-to-fail Assert). Yes, its for discussion. How would you describe such a patch in the future? I want to be able to

[PATCHES] [8.4] Updated WITH clause patch (non-recursive)

2008-01-26 Thread Neil Conway
Attached is an updated version of Greg Stark's patch to add support for the non-recursive variant of the SQL99 WITH clause[1]. I haven't looked at the actual functionality of the patch yet (which is quite trivial) -- I just fixed up bitrot and the like. I also removed support for RECURSIVE and the