PgSql

[HACKERS] Strange heuristic in analyze.c
So I never realized the consequences of this little heuristic in analyze.c in the handling of very low cardinality columns where we want to just capture the complete list of values in the mcv and throw away the histogram: else if (toowide_cnt == 0 && nmultiple == ndistinct) { /* * Every value in the... 2 Feb 2010 16:07

[HACKERS] ordered aggregates using WITHIN GROUP (was Re: can somebodyexecute this query on Oracle 11.2g and send result?)
Jonah H. Harris escribi�: The syntax is listagg(expression [, delimiter]) WITHIN GROUP (order by clause) [OVER partition clause] If a delimiter is defined, it must be a constant. Query: SELECT listagg(a, ',') WITHIN GROUP (ORDER BY a) FROM foo; Result: aaa,bbb,ccc So that's how Oracle supports o... 2 Feb 2010 16:07

helpers to convert C types to postgres types (Array)
On Fri, Jan 29, 2010 at 7:34 AM, Ivan Sergio Borgonovo <mail(a)webthatworks.it> wrote: I'm still trying to collect all the bits to be able to read and return several types of data in C functions. I'm looking for quick ways to deal with ArrayType. I'd expect some helper because these kind of operation s... 2 Feb 2010 16:07

[HACKERS] [CFReview] Red-Black Tree
Hi Robert, I've also spent some time reviewing this patch since it is a pre-requisite to the KNNGiST patch. I did have a much more comprehensive list of suggestions, but it seems you've managed to resolve most of these with your latest re-write. Please find some more comments inline: Here's an edited version... 2 Feb 2010 16:07

WARNING: pgstat wait timeout
I just found a few of these errors in a log file during some pgbench testing tonight. Linux, recent CVS HEAD; given the range of systems and versions this has been reported against now, this bug doesn't look like a platform or version/build specific issue. Unfortunately the instance I had up wasn't setup very... 2 Feb 2010 16:07

64-bit size pgbench
Greg Smith <greg(a)2ndquadrant.com> wrote: Attached is a patch that fixes a long standing bug in pgbench: it won't handle scale factors above ~4000 (around 60GB) because it uses 32-bit integers for its computations related to the number of accounts, and it just crashes badly when you exceed that. Thi... 2 Feb 2010 16:08

out-of-scope cursor errors
Andrew Dunstan �rta: We seem to have a large portion of the buildfarm red from the ECPG tests, presumably due to the recently applied out-of-scope cursor patches. cheers andrew Hi. I know. Patches were already posted for that, waiting for Michael to review and apply it. Look at the commi... 2 Feb 2010 16:07

[HACKERS] out-of-scope cursor errors
We seem to have a large portion of the buildfarm red from the ECPG tests, presumably due to the recently applied out-of-scope cursor patches. cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsq... 2 Feb 2010 16:07

Add on_perl_init and proper destruction to plperl UPDATED[PATCH]
Tim Bunce wrote: This is an updated version of the third of the patches to be split out from the former 'plperl feature patch 1'. It includes changes following discussions with Tom Lane and others. Changes in this patch: - Added plperl.on_perl_init GUC for DBA use (PGC_SIGHUP) SPI fun... 2 Feb 2010 16:07

[HACKERS] returning array in a field together with other types
I'm trying to return a set of record as: (text, int[]), (text, int[]), .... row from C and I really would like to avoid to use BuildTupleFromCString So this is how I think my function should end... char *curout; /* cstring */ int4 *pos; .... get_typlenbyvalalign(INT4OID, &typlen, &typbyval, &typalign)... 2 Feb 2010 16:07