Road map to study about fetching a set of tuples - novice!

Sent from my iPad

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

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 via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Thanks, it's helpful.

The flowchart is a very good point to start.

Cheers,
Soroosh

On Sat, May 18, 2013 at 7:56 PM, Atri Sharma <atri.jiit@gmail.com> wrote: