Home > mailing lists

Re: how the planner decides between bitmap/index scan - Mailing list pgsql-general

From	Scara Maccai
Subject	Re: how the planner decides between bitmap/index scan
Date	May 19, 2009 08:51:30
Msg-id	367727.47532.qm@web24607.mail.ird.yahoo.com Whole thread Raw
In response to	how the planner decides between bitmap/index scan (Scara Maccai <m_lists@yahoo.it>)
List	pgsql-general

Tree view

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?

pgsql-general by date:

From: Sebastien FLAESCH
Date: 19 May 2009, 08:39:13
Subject: INTERVAL SECOND limited to 59 seconds?

From: Richard Huxton
Date: 19 May 2009, 08:54:34
Subject: Re: INTERVAL SECOND limited to 59 seconds?

Re: how the planner decides between bitmap/index scan - Mailing list pgsql-general

Previous

Next