Re: [HACKERS] Idea for minor tstore optimization

2008-03-25 Thread Neil Conway
On Sat, 2008-03-22 at 21:24 -0400, Tom Lane wrote: Oh, wait, that's just a -patches entry; it doesn't look like Neil ever committed it. Neil, how come? Sorry, slipped through the cracks -- I've now committed the patch. -Neil -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Idea for minor tstore optimization

2008-03-22 Thread Bruce Momjian
Added to TODO: * Avoid tuple some tuple copying in sort routines http://archives.postgresql.org/pgsql-hackers/2008-02/msg01206.php --- Tom Lane wrote: Neil Conway [EMAIL PROTECTED] writes: I notice that several of

Re: [HACKERS] Idea for minor tstore optimization

2008-03-22 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Added to TODO: * Avoid tuple some tuple copying in sort routines http://archives.postgresql.org/pgsql-hackers/2008-02/msg01206.php Actually ... isn't this done already? http://archives.postgresql.org/pgsql-patches/2008-02/msg00176.php

Re: [HACKERS] Idea for minor tstore optimization

2008-03-22 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Added to TODO: * Avoid tuple some tuple copying in sort routines http://archives.postgresql.org/pgsql-hackers/2008-02/msg01206.php Actually ... isn't this done already?

Re: [HACKERS] Idea for minor tstore optimization

2008-03-22 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: Actually ... isn't this done already? http://archives.postgresql.org/pgsql-patches/2008-02/msg00176.php Yea, removed because I thought you just did it. Oh, wait, that's just a -patches entry; it doesn't look like Neil ever committed it.

Re: [HACKERS] Idea for minor tstore optimization

2008-03-22 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: Actually ... isn't this done already? http://archives.postgresql.org/pgsql-patches/2008-02/msg00176.php Yea, removed because I thought you just did it. Oh, wait, that's just a -patches entry; it doesn't look like

Re: [HACKERS] Idea for minor tstore optimization

2008-03-22 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: Oh, wait, that's just a -patches entry; it doesn't look like Neil ever committed it. Neil, how come? I thought this was Neil's commit that you just did: No, the one I just put in was the one you have listed under Avoid needless copy in

Re: [HACKERS] Idea for minor tstore optimization

2008-03-22 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: Oh, wait, that's just a -patches entry; it doesn't look like Neil ever committed it. Neil, how come? I thought this was Neil's commit that you just did: No, the one I just put in was the one you have listed

[HACKERS] Idea for minor tstore optimization

2008-02-27 Thread Neil Conway
I notice that several of the call sites of tuplestore_puttuple() start with arrays of datums and nulls, call heap_form_tuple(), and then switch into the tstore's context and call tuplestore_puttuple(), which deep-copies the HeapTuple into the tstore. ISTM it would be faster and simpler to provide

Re: [HACKERS] Idea for minor tstore optimization

2008-02-27 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: I notice that several of the call sites of tuplestore_puttuple() start with arrays of datums and nulls, call heap_form_tuple(), and then switch into the tstore's context and call tuplestore_puttuple(), which deep-copies the HeapTuple into the tstore. ISTM