A question to all pg hackers
Is anybody working on adding pipelining to set returning functions.
How much effort would it take ?
Where should I start digging ?
BACKGROUND:
AFAICS , currently set returning functions materialise their results
before returning, as seen by this simple test:
hannu
On Sat, Apr 05, 2008 at 05:57:35PM -0400, Tom Lane wrote:
> So the proposed changes in hash_any make its hash values different
> between big-endian and little-endian machines (at least for string keys;
> for keys that are really arrays of int, I think the changes will
> unify the behavior). This m
"Tom Lane" <[EMAIL PROTECTED]> writes:
> SELECT dblink_get_connections();
>dblink_get_connections
>
> ! {dtest1,dtest3,dtest2}
> (1 row)
>
> SELECT dblink_is_busy('dtest1');
>
> and right offhand I can't think of a simple way to force those array
> element
Hi,
D'Arcy J.M. Cain wrote:
...
Yes but what I am suggesting goes beyond that. My idea is that there
is a modules directory that contains a file for each installable
module. This file would contain all the information about the module
such as name, version, where to get the actual package, an
On Sun, Apr 06, 2008 at 10:01:20AM +0300, Hannu Krosing wrote:
> A question to all pg hackers
>
> Is anybody working on adding pipelining to set returning functions.
>
> How much effort would it take ?
>
> Where should I start digging ?
>
> BACKGROUND:
>
> AFAICS , currently set returning func
Hannu Krosing wrote:
A question to all pg hackers
Is anybody working on adding pipelining to set returning functions.
Not as far as I know.
How much effort would it take ?
Where should I start digging ?
I don't remember all the details, but I think the original SRF patch
that I did was p
I'm working over Pavel's FOR-over-cursor patch:
http://archives.postgresql.org/pgsql-patches/2007-12/msg1.php
(Although I previously complained that this was a bit pointless,
the argument that it's important for porting Oracle code won me over.)
I noticed that because the patch uses the same
"Tom Dunstan" <[EMAIL PROTECTED]> writes:
> - I'd like to add pg_depend entries for stuff installed by the module
> on the pd_module entry, so that you can't drop stuff required by the
> module without uninstalling the module itself. There would have to be
> either a function or more syntax to al
I wrote:
> I wonder whether anyone knows
> if Oracle users expect this combination to work at all?
Nevermind that ... I found an example of this in Oracle's own docs,
so clearly it had better work. Patch applied with appropriate fixes.
regards, tom lane
--
Sent via pgsq
Gregory Stark wrote:
> We currently execute a lot of joins as Nested Loops which would be more
> efficient if we could batch together all the outer keys and execute a single
> inner bitmap index scan for all of them together.
>
> Essentially what I'm saying is that we're missing a trick with Hash
Magnus, have you looked at this yet?
---
Gregory Stark wrote:
>
> There's a suspicious ifdef in pg_standby for WIN32 which smells like a kludge
> added to work around a Windows problem which makes it work but at great
> exp
Gregory Stark <[EMAIL PROTECTED]> writes:
> I've been hacking on the idea of an Append node which maintains the ordering
> of its subtables merging their records in order.
I finally got round to looking at this ...
> 1) I still haven't completely figured out what to do with equivalence classes.
>
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> Attached is a version as good as I know how to get it.
> It works for us, so barring any problems as we use it, I'm done.
I finally got around to looking at this. Neither nor err()
are portable (they're not in the Single Unix Spec, and they don't
wo
no. I have been without a working win32 build environment for a while. Working
on fixing that right now..
/Magnus
> --- Original Message ---
> From: Bruce Momjian <[EMAIL PROTECTED]>
> To: Gregory Stark <[EMAIL PROTECTED]>, Magnus Hagander <[EMAIL PROTECTED]>
> Sent: 08-04-07, 1:54:37
>
On Sun, Sep 9, 2007 at 4:16 AM, apoc9009 <[EMAIL PROTECTED]> wrote:
>
> No! Actually I'm wearing my tin hat right now and I Never say Anything
> > about My Suspicions about 9/11 on Internet in fear of Echelon catching
> > and filing me.
> >
> > ---
> > Hannu
> >
> hmm, a little bit Pa
On Mon, Apr 7, 2008 at 3:59 AM, Gregory Stark <[EMAIL PROTECTED]> wrote:
> I wonder if there's much of a use case for any statements aside from CREATE
> statements. If we restrict it to CREATE statements we could hack things to
> create pg_depend entries automatically. In which case we wouldn't
16 matches
Mail list logo
