Re: Optimizer showing wrong rows in plan

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема Re: Optimizer showing wrong rows in plan
Дата
Msg-id e4edc9361003280029v7174f84bo72d073aced772206@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Optimizer showing wrong rows in plan  (Tadipathri Raghu <traghu.dba@gmail.com>)
Ответы Re: Optimizer showing wrong rows in plan
Список pgsql-performance


2010/3/28 Tadipathri Raghu <traghu.dba@gmail.com>
Hi Guz,
 
Thank you for the prompt reply.
 
No, the optimizer is not retrieving anything, it just assumes that there are 2400 rows because that is the number of rows that exists in the statictics for this table. The optimizer just tries to find the best plan and to optimize the query plan for execution taking into consideration all information that can be found for this table (it also looks in the statistics information about rows from this table).
 
So, whats it assuming here as rows(2400).  Could you explain this.
 


It is assuming that there are 2400 rows in this table. Probably you've deleted some rows from the table leaving just one.

regards
Szymon Guz 

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tadipathri Raghu
Дата:
Сообщение: Re: Optimizer showing wrong rows in plan
Следующее
От: Tadipathri Raghu
Дата:
Сообщение: Re: Optimizer showing wrong rows in plan