Re: GSOC 2015: Student Introduction

Hello,
My name is Hitesh Ramani, I'm a student of Hyderabad Central University, Hyderabad, India. Currently I'm pursuing a project in PostgreSQL as my Post Graduation project hence I've hacked into the Postgres code a lot of times to add some functionalities to it, specifically to the sorting code. I'm also familiar with the query processing and backend internals.
I'm keen to know the kind of projects Postgres will be floating this year for GSOC.
Hoping for a response.
Thank You.Hitesh Ramani

On 21 February 2015 at 19:36, hitesh ramani <hiteshramani(at)hotmail(dot)com> wrote:
>
>
> Hello,
>
> My name is Hitesh Ramani, I'm a student of Hyderabad Central University, Hyderabad, India. Currently I'm pursuing a project in PostgreSQL as my Post Graduation project hence I've hacked into the Postgres code a lot of times to add some functionalities to it, specifically to the sorting code. I'm also familiar with the query processing and backend internals.
>
> I'm keen to know the kind of projects Postgres will be floating this year for GSOC.

Hi Hitesh,

Do you have any particular area you wish to work on, or a feature
you'd like to add? You can find some project ideas on the GSoC 2015
wiki page here:
https://wiki.postgresql.org/wiki/GSoC_2015#Project_Ideas

Regards

Thom

On Tue, Mar 3, 2015 at 8:16 AM, Thom Brown <thom(at)linux(dot)com> wrote:
>
> Do you have any particular area you wish to work on, or a feature
> you'd like to add? You can find some project ideas on the GSoC 2015
> wiki page here:
> https://wiki.postgresql.org/wiki/GSoC_2015#Project_Ideas
>

Thom,

I removed the above idea because it's already implemented.
* parallel vacuumdb

Regards,

[1]
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=a17923204736d8842eade3517d6a8ee81290fca4

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello

Hi Thom,
Glad to see your response. I apologize for the delay in response due to some official work.
>Do you have any particular area you wish to work on, or a feature
>you'd like to add?
Yes, as I said, I'm working on the sorting enhancements, I would like to propose enhancing the sorting using parallel architectures, specifically CUDA. I've been doing some research on this and I think it is very much possible. As Postgres has capabilities to handle massive number of elements and sorting is an important component in order by queries.
>You can find some project ideas on the GSoC 2015
>wiki page here:
>https://wiki.postgresql.org/wiki/GSoC_2015#Project_Ideas

I saw the wiki but the ideas stated there are very vague in sense, only a few have details, any plans to add more details and skills to the titles?
Looking forward to hear from you.
Thanks and Regards,Hitesh Ramani

On 03/04/2015 02:56 AM, hitesh ramani wrote:
> Yes, as I said, I'm working on the sorting enhancements, I would like to
> propose enhancing the sorting using parallel architectures, specifically
> CUDA. I've been doing some research on this and I think it is very much
> possible. As Postgres has capabilities to handle massive number of
> elements and sorting is an important component in order by queries.

This sounds like a great project. Please submit it to the GSOC form.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

On Thu, Mar 5, 2015 at 12:01 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:

> On 03/04/2015 02:56 AM, hitesh ramani wrote:
> > Yes, as I said, I'm working on the sorting enhancements, I would like to
> > propose enhancing the sorting using parallel architectures, specifically
> > CUDA. I've been doing some research on this and I think it is very much
> > possible. As Postgres has capabilities to handle massive number of
> > elements and sorting is an important component in order by queries.
>
> This sounds like a great project. Please submit it to the GSOC form.
>

Something like PG Strom?

Hello Josh,

> This sounds like a great project. Please submit it to the GSOC form.

Can you provide me the link to submit the idea?
Thanks and Regards,Hitesh Ramani

Hello Atri,
>>Something like PG Strom?

Yes, you may say something like that, but sorting and aggregation is still to be done in PG Strom. And I see much use for it in mathematical calculations but not internal operations. Please correct me if I'm wrong.
Thanks and Regards,Hitesh Ramani

Hi Thom,
I was wondering if you could guide me a little on the area I'd like to work on for me to have a quicker start?
Regards,Hitesh Ramani

From: hiteshramani(at)hotmail(dot)com
To: thom(at)linux(dot)com
CC: pgsql-students(at)postgresql(dot)org
Subject: Re: [pgsql-students] GSOC 2015: Student Introduction
Date: Wed, 4 Mar 2015 16:26:08 +0530

Hi Thom,
Glad to see your response. I apologize for the delay in response due to some official work.
>Do you have any particular area you wish to work on, or a feature
>you'd like to add?
Yes, as I said, I'm working on the sorting enhancements, I would like to propose enhancing the sorting using parallel architectures, specifically CUDA. I've been doing some research on this and I think it is very much possible. As Postgres has capabilities to handle massive number of elements and sorting is an important component in order by queries.
>You can find some project ideas on the GSoC 2015
>wiki page here:
>https://wiki.postgresql.org/wiki/GSoC_2015#Project_Ideas

I saw the wiki but the ideas stated there are very vague in sense, only a few have details, any plans to add more details and skills to the titles?
Looking forward to hear from you.
Thanks and Regards,Hitesh Ramani

* hitesh ramani (hiteshramani(at)hotmail(dot)com) wrote:
> Hello Atri,
> >>Something like PG Strom?
>
> Yes, you may say something like that, but sorting and aggregation is still to be done in PG Strom. And I see much use for it in mathematical calculations but not internal operations. Please correct me if I'm wrong.

You'll seriously need to differentiate what your proposal is from the
existing PG Strom project for it to make sense to accept as truely
independent from that effort, if that's your intent. Further, I expect
that you'll need to find a mentor who has access to the same kind of
environment which you have access to where you'll be doing this work (we
are unable to provide any hardware to you for this effort, as I
understand it).

Thanks,

Stephen

Hello Stephen,
Thank you for the response.
> You'll seriously need to differentiate what your proposal is from the
> existing PG Strom project for it to make sense to accept as truely
> independent from that effort, if that's your intent.
I will definitely write strong points which will differ my proposal from PG Strom.
> Further, I expect that you'll need to find a mentor who has access to the same kind of
> environment which you have access to where you'll be doing this work (we
> are unable to provide any hardware to you for this effort, as I
> understand it).

I have access to a NVidia GPU(Quodro K600). This is the only hardware I need I suppose to run the CUDA code. Moreover, as CUDA runs on most of the NVidia GPUs(as listed on the Nvidia website), anyone having a NVidia CUDA compatible GPU can help me with this.
Thanks and Regards,Hitesh Ramani