Thread: Road map to study about fetching a set of tuples - novice!
Hi
I was tracing a simple SELECT query to find how pg works for fetching tuples.I know about parsing and planning parts, my actual problem is executer.
If you show me a road map to study, I would appreciate it.
Regards
Soroosh
Sent from my iPad
Could you help me to understand under the hood?but I'm totally lost in the code.HiI was tracing a simple SELECT query to find how pg works for fetching tuples.I know about parsing and planning parts, my actual problem is executer.If you show me a road map to study, I would appreciate it.
You can probably try:
Regards,
Atri
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Em 18-05-2013 11:40, Atri Sharma escreveu: > On 18-May-2013, at 20:01, Soroosh Sardari > <soroosh.sardari@gmail.com> wrote: > >> Hi >> >> I was tracing a simple SELECT query to find how pg works for >> fetching tuples. but I'm totally lost in the code. Could you >> help me to understand under the hood? I know about parsing and >> planning parts, my actual problem is executer. If you show me a >> road map to study, I would appreciate it. >> >> > > You can probably try: > > http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/executor/README;h=8afa1e3e4a7596475cbf19a76c88d48a04aeef02;hb=HEAD > There > > is a cool flowchart too: http://www.postgresql.org/developer/backend/ []s - -- Dickson S. Guedes mail/xmpp: guedes@guedesoft.net - skype: guediz http://guedesoft.net - http://www.postgresql.org.br http://github.net/guedes - twitter: @guediz -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJRl5wHAAoJEBa5zL7BI5C7C+wH/2dO5t5G4ygLUE2jlHOgpbkZ wcXxED5h5TvQel2N2c1WmmMuxPeTJwjxoUOoO9v4sA+pf2YmOphrv77rQN5DIMW8 iKxZQpe+c7cblgQpZx0gTuswRrbPIhMSAF0zP2SS2GFxPKEWD4Oe3QbkNnkZTD0X xZfSRiSnTe3d7mO9ok41BUndTQdvIz6bV/1v7CMV/YKlM6N0uMMVYORJBGw9kKK4 lxuFek2vpR5Np7DeDIeHoFk8fKJbJFcqBHi5Hs8f3AGoF4u4MMxPMoYK6dZmj7Tr YeHkWP8UEx06OBSm+k3BCRb3A7lnsObtLnykU8r4VUK9X1fwpz1Atx4mGwQucus= =GPkw -----END PGP SIGNATURE-----
Sent from my iPad On 18-May-2013, at 20:49, "Dickson S. Guedes" <listas@guedesoft.net> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Em 18-05-2013 11:40, Atri Sharma escreveu: >> On 18-May-2013, at 20:01, Soroosh Sardari >> <soroosh.sardari@gmail.com> wrote: >> >>> Hi >>> >>> I was tracing a simple SELECT query to find how pg works for >>> fetching tuples. but I'm totally lost in the code. Could you >>> help me to understand under the hood? I know about parsing and >>> planning parts, my actual problem is executer. If you show me a >>> road map to study, I would appreciate it. >>> >>> >> >> You can probably try: >> >> http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/executor/README;h=8afa1e3e4a7596475cbf19a76c88d48a04aeef02;hb=HEAD >> > > > There >> >> > is a cool flowchart too: > > http://www.postgresql.org/developer/backend/ > Oh yes, I am in love with that flow chart.It is so easy and expressive! Regards, Atri
Thanks, it's helpful.
The flowchart is a very good point to start. On Sat, May 18, 2013 at 7:56 PM, Atri Sharma <atri.jiit@gmail.com> wrote:
Sent from my iPadOh yes, I am in love with that flow chart.It is so easy and expressive!
On 18-May-2013, at 20:49, "Dickson S. Guedes" <listas@guedesoft.net> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Em 18-05-2013 11:40, Atri Sharma escreveu:
>> On 18-May-2013, at 20:01, Soroosh Sardari
>> <soroosh.sardari@gmail.com> wrote:
>>
>>> Hi
>>>
>>> I was tracing a simple SELECT query to find how pg works for
>>> fetching tuples. but I'm totally lost in the code. Could you
>>> help me to understand under the hood? I know about parsing and
>>> planning parts, my actual problem is executer. If you show me a
>>> road map to study, I would appreciate it.
>>>
>>>
>>
>> You can probably try:
>>
>> http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/executor/README;h=8afa1e3e4a7596475cbf19a76c88d48a04aeef02;hb=HEAD
>>
>
>
> There
>>
>>
> is a cool flowchart too:
>
> http://www.postgresql.org/developer/backend/
>
Regards,
Atri