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 <ring...@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 >
