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 > > http://archives.postgresql.org/pgsql-performance/2008-0

[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 Bauman

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 diff

[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