[GENERAL] how the planner decides between bitmap/index scan

Hi, does the planner know how scattered rows are? If yes: where is this info stored? I'm asking because it looks to me that not only the number of rows, but also how data is on disk (more or less sequential) is used to determine what type of index scan (bitmap/regular) has to be used... but

Re: [GENERAL] how the planner decides between bitmap/index scan

Ops, found it: http://www.postgresql.org/docs/8.4/static/view-pg-stats.html (correlation column) I guess it would be worth pointing it out in the planner docs... Scara Maccai wrote: Hi, does the planner know how scattered rows are? If yes: where is this info stored? -- Sent via