Re: using custom scan nodes to prototype parallel sequential scan

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: using custom scan nodes to prototype parallel sequential scan
Date: 2014-11-14 11:42:59
Message-ID: CAApHDvr2Nx+tHW+YBR1ON+Qp87eros0nN5skNwiHBy21GJSvgA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Nov 14, 2014 at 1:27 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:

> On 12 November 2014 00:54, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> > Interestingly, I have a fairly solid idea of what proisparallel is,
> > but I have no clear idea what CONTAINS NO SQL is or why it's relevant.
> > I would imagine that srandom() contains no SQL under any reasonable
> > definition of what that means, but it ain't parallel-safe.
>
> What is wrong in generating random numbers in parallel?
>

I was just watching Robert's talk on Parallel query on youtube... I think
the answer is at 41:09, the link below should take you there:
https://www.youtube.com/watch?v=3klfarKEtMQ#t=2469

Regards

David Rowley

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2014-11-14 13:35:25 Re: Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS
Previous Message Jeremy Harris 2014-11-14 11:06:47 Re: EXPLAIN ANALYZE output weird for Top-N Sort