Questions about planner methods

Started by Kevin Kempterabout 19 years ago2 messages
#1Kevin Kempter
kevin@kevinkempterllc.com

Hi List(s);

I'm wanting to find more details per the following methods, can someone
explain to me exactly what each of these methods is, how its implemented in
postgres or point me to some docs or README's that explain these methods?

Some of 'em are obviously no-brainers but I'm writing a postgres book and want
to make sure I convey the concepts properly and technically correct.

- Bitmap Scans
- Hash Aggregation
- Hash Joins
- Index Scans
- Merge Joins
- Nested Loop Joins
- TID Scans

Thanks in advance for your help...

#2Martijn van Oosterhout
kleptog@svana.org
In reply to: Kevin Kempter (#1)
Re: [HACKERS] Questions about planner methods

On Sun, Dec 24, 2006 at 12:15:18PM -0700, Kevin Kempter wrote:

Hi List(s);

I'm wanting to find more details per the following methods, can someone
explain to me exactly what each of these methods is, how its implemented in
postgres or point me to some docs or README's that explain these methods?

There's plenty of the comments in the files that implement them (the
executor directory. Have you checked them?

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Show quoted text

From each according to his ability. To each according to his ability to litigate.