Re: PostgreSQL derivatives

Josh, may I quote this in a possible blog article? --

> Greenplum has re-written the executor and bulk loader, and seems to be
> on the way to re-writing the planner entirely. Yahoo and Netezza each
> pretty much ripped out everthing except for the parser and a few other
> bits (Yahoo kept the Function code, for example), but replaced a
> majority of the PostgreSQL code.

I'm not sure I'll use it however. If I do, how would you like to be
identified PostgreSQL wise?

Thanks,

Seth

On Sun, 8 Jun 2008, Josh Berkus wrote:

> Seth,
>
>> My understanding is that the MPP vendors using PostgreSQL and Ingres are
>> not *significantly* altering the software other than to, essentially, turn
>> off reliance on indexes. They're then adding extensions that are
>> proprietary and not, except in the case of GridSQL, open source. Is my
>> understanding correct?
>
> Actually, that's incorrect. Greenplum, Yahoo and Netezza all made
> substantial alterations to the PostgreSQL code. Greenplum has re-written the
> executor and bulk loader, and seems to be on the way to re-writing the
> planner entirely. Yahoo and Netezza each pretty much ripped out everthing
> except for the parser and a few other bits (Yahoo kept the Function code, for
> example), but replaced a majority of the PostgreSQL code.
>
> I wouldn't classify GridSQL as MPP. It's strictly PP.
>
> --Josh Berkus
>
>

--
Seth Grimes Alta Plana Corp, analytical computing & data management
Intelligent Enterprise magazine (CMP), Contributing Editor
grimes(at)altaplana(dot)com http://altaplana.com 301-270-0795