Re: [DOCS] How the planner uses statistics
Mark, > > I wanted to understand how the planner 'knows' how many rows are likely > > to be emitted in a given stage of a query, and wrote down some examples > > for my own benefit - I then wondered if this would be a good addition to > > the 'Performance Tips' chapter. So... err here it is. > > > > Comments welcome. Terrific. I'd be happy to post this at www.powerpostgresql.org, if you want; I think a lot of people would be interested. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [DOCS] How the planner uses statistics
On Sat, Feb 12, 2005 at 03:22:10PM -0800, Josh Berkus wrote: > > Terrific. I'd be happy to post this at www.powerpostgresql.org, if you > want; Shouldn't that be www.powerpostgresql.com? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [DOCS] How the planner uses statistics
Josh Berkus wrote: Mark, Terrific. I'd be happy to post this at www.powerpostgresql.org, if you want; I think a lot of people would be interested. Absolutely, that is an excellent spot for it, do you need it reformatted in html first? BTW - in fact a community site may well be more appropriate for it than the docs, as someone has to remember to change it if (when) the optimizer row estimation algorithms or stats design are altered. Mark ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
