Thanks to all for all the good advice. I was thinking myself to work in any of the open source project and contribute there. As a database developer I think Postgresql is one of the best places for me where I may enjoy working and see the outcome.
If you ask about goal, I was thinking to work in a large project where the great hacker may be working for parallel execution of a query. At present, I need it badly. I know I may achieve a bit of that using pgpool load balancer or grid sql. But it would be nice if we get it at core Postgresql.
Criag, you really tell a good point. At first I should start by writing simple C functions as extension and then for more.
Thanks to all again.
On Tue, Jul 3, 2012 at 7:32 PM, Craig Ringer
<ringerc@ringerc.id.au> wrote:
On 07/03/2012 07:50 PM, AI Rumman wrote:
Hello,
I have been working with Postgresql for the last 3 years. Before that I worked with Oracle, Mysql and other databases.
Now, its time to learn the internals of Postgresql system. I downloaded the source code and imported it in my eclipse environment.
But I have very limited knowledge on C programming.
Could you guys please guide me from where I should start?
If you really want to start messing with the Pg innards, and you have already read and understood all the developer documentation, I'd suggest starting by writing some simple user defined functions in C. Write a simple function that returns a plain value. Then a record. Then a set of records. Then write an aggregate function. Then a window function. Dig into the data structures and types. When you're game, implement a simple data type. Then add support for indexing it. etc.
Honestly, if you don't have something you want to _achieve_ it's probably mostly going to be boring. What do you want to do, to get out of this?
--
Craig Ringer