PgSql

MonetDB test says that PostgreSQL often has errorsor missing results
Mark Wong wrote: What the TPC provides isn't really a usable kit. It could be entertaining to see how their kit works. The one for TPC-H seems to work for a lot of people; the best of the intros I found for how to make it go was http://bhairav.serc.iisc.ernet.in/doc/Installation/tpch.htm , there are... 20 Jan 2010 17:26

[NOVICE] Python verison for build in config.pl (Win32)
On Wed, Jan 20, 2010 at 18:59, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: Matt <bsg075(a)gmail.com> writes: Attempting to build 8.5 alpha on Windows XP (MSVC 2005) with Python support. Path to local interpreter added to config.pl (C:\Python), but message is presented:   "Could not determine python version ... 14 Feb 2010 09:34

Synchronization primitives (Was: Re: [HACKERS] An example of bugsfor Hot Standby)
Andres Freund wrote: On Wednesday 20 January 2010 17:59:36 Tom Lane wrote: Andres Freund <andres(a)anarazel.de> writes: I realize its way too late in the cycle for that, but why dont we start using some library for easy cross platform atomic ops? (1) there probably isn't one that does exactly what we... 20 Jan 2010 14:03

Bloom filters bloom filters bloom filters
> Then your union operation is to just bitwise or the two bloomfilters. Keep in mind that when performing this sort of union between two comparably-sized sets, your false-positive rate will increase by about an order of magnitude. You need to size your bloom filters accordingly, or perform the union differently. In... 20 Jan 2010 11:46

Review: Patch: Allow substring/replace() to get/set bit values
Leonardo F wrote: New version of the patch, let me know if I can fix/change something else. All issues addressed, with one tiny nit-pick -- the get_bit and set_bit methods are not part of the SQL standard. I took the liberty of removing "SQL-standard" from the documentation of these functions so that I can ... 25 Jan 2010 17:22

Bug ? different behaviour between 8.3 and 8.4 won ISNULL with sub arrays of nulls
On Tue, 19 Jan 2010, Tom Lane wrote: ioguix(a)free.fr writes: I found a difference of behaviour between 8.3 and 8.4 on IS NULL with multi-level arrays with NULL values. 8.3's behavior is just a bug --- Ok, should I report through the -bugs ml for tracking purpose ? or is it useless cause it's on -... 20 Jan 2010 05:06

Add utility functions to plperl [PATCH]
Tim Bunce wrote: This is the first of the patches to be split out from the former 'plperl feature patch 1'. Changes in this patch: - Added utility functions: quote_literal, quote_nullable, quote_ident, encode_bytea, decode_bytea, looks_like_number, encode_array_literal, encode_array_... 19 Jan 2010 21:27

[HACKERS] Patch rev 2: MySQL-ism help patch for psql
On Jan 19, 2010, at 4:23 PM, Robert Haas wrote: On Tue, Jan 19, 2010 at 5:14 PM, David E. Wheeler <david(a)kineticode.com wrote: Why would they want more? It's not MySQL, and they know that. If we give them some very minor helpful hints for the most common things they try to do, it would be a... 19 Jan 2010 19:12

[HACKERS] Missing docs for SR
Hackers, So, here's a must-fix item for SR for release: we need adequate docs. I'm happy to write these but *I* need to understand the answers first. The current docs and wiki page do not explain: * How (technically) the slave listens for LSNs * Does the walreceiver need the archive (via archive_command) cop... 19 Jan 2010 18:04

[HACKERS] MonetDB test says that PostgreSQL often has errors or missing results
See: http://monetdb.cwi.nl/SQL/Benchmark/TPCH/ If the result is correct, then the problem queries should be added to the regression test suite. If the result is not correct, then perhaps they could get assistance on proper configuration of PostgreSQL and rerun the tests. -- Sent via pgsql-hackers mailing ... 19 Jan 2010 15:48