PgSql

Review: Patch for phypot - Pygmy Hippotause
Andrew Geery <andrew.geery(a)gmail.com> wrote: The HYPOT macro executed 100 million times in 11 seconds and the phypot function executed the same number of times in 22 seconds. Or, to put that another way, the new function adds 110 nanoseconds to each hypotenuse calculation. With both -O2 and -O3, the... 3 Aug 2010 18:03

Fwd: [HACKERS] gSoC - ADD MERGE COMMAND - code patch submission
---------- Forwarded message ---------- From: Boxuan Zhai <bxzhai2010(a)gmail.com> Date: 2010/7/17 Subject: Re: [HACKERS] gSoC - ADD MERGE COMMAND - code patch submission To: Simon Riggs <simon(a)2ndquadrant.com> 2010/7/17 Simon Riggs <simon(a)2ndquadrant.com> On Fri, 2010-07-16 at 08:26 +0800, Boxuan Zhai w... 17 Jul 2010 08:44

Performance Enhancement/Fix for Array Utility Functions
Daniel Farina <drfarina(a)acm.org> writes: Generally I think the delimited untoasting of metadata from arrays separately from the payload is Not A Bad Idea. I looked at this patch a bit. I agree that it could be a big win for large external arrays, but ... 1. As-is, it's a significant *pessimization* for sm... 5 Aug 2010 14:40

[HACKERS] Review: Patch for phypot - Pygmy Hippotause
This is a review of the phypot - Pygmy Hippotause patch: http://archives.postgresql.org/message-id/4A9897E1.8090703(a)netspace.net.au submitted by Paul Matthews. Contents & Purpose ================== The purpose of the patch is to compute a hypotenuse with higher precision than the current implementation (the HYP... 16 Jul 2010 14:21

[HACKERS] review: psql: edit function, show function commands patch
Hi, here's a review of the \sf and \ef [num] patch from http://archives.postgresql.org/message-id/162867791003290927y3ca44051p80e697bc6b19de29(a)mail.gmail.com == Formatting == The patch has some small tabs/spaces and whitespace issues and it applies with some offsets, I ran pgindent and rebased against HEAD... 16 Jul 2010 13:14

putting plproxy in pg_pltemplate
On fre, 2010-07-16 at 14:13 +0300, Hannu Krosing wrote: Should we put some externally managed languages , like pl/proxy also in pgtemplate, so that CREATE LANGUAGE would work on them ? This has been rejected several times before. See: http://archives.postgresql.org/pgsql-hackers/2009-01/msg00050.php -... 16 Jul 2010 16:35

[HACKERS] psql auto-completion for multiple where clauses
Someone highlighed on IRC that after the first WHERE clause, autocomplete no longer works. An example: CREATE TABLE tab_completion ( id serial, stuff text, meow boolean ); SELECT * FROM tab_completion WHERE id = 2 AND s<tab><tab> This would output a blank line. Is there any chance of improving this ... 16 Jul 2010 13:14

psql auto-completion for multiple where clauses
On 16 July 2010 16:04, Greg Sabino Mullane <greg(a)turnstep.com> wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Someone highlighed on IRC that after the first WHERE clause, autocomplete no longer works. ... SELECT * FROM tab_completion WHERE id = 2 AND s<tab><tab> ... Is th... 16 Jul 2010 13:15

[HACKERS] putting plproxy in pg_pltemplate
Hi Should we put some externally managed languages , like pl/proxy also in pgtemplate, so that CREATE LANGUAGE would work on them ? -- Hannu Krosing http://www.2ndQuadrant.com PostgreSQL Scalability and Availability Services, Consulting and Training -- Sent via pgsql-hackers mailing list (pg... 16 Jul 2010 07:43

pgsql: Ensure that top level aborts call XLogSetAsyncCommit().
On Mon, May 31, 2010 at 8:48 PM, Simon Riggs <simon(a)2ndquadrant.com> wrote: On Mon, 2010-05-31 at 20:11 +0900, Fujii Masao wrote: On Thu, May 13, 2010 at 8:39 PM, Simon Riggs <sriggs(a)postgresql.org> wrote: Log Message: ----------- Ensure that top level aborts call XLogSetAsyncCommit(). Not doin... 16 Jul 2010 12:07