Re: ORDER BY ... LIMIT and JOIN

От: Michael Andreen
Тема: Re: ORDER BY ... LIMIT and JOIN
Дата: ,
Msg-id: 200908081909.48708.harv@ruin.nu
(см: обсуждение, исходный текст)
Ответ на: ORDER BY ... LIMIT and JOIN  (Fizu)
Ответы: Re: ORDER BY ... LIMIT and JOIN  (Fizu)
Список: pgsql-performance

Скрыть дерево обсуждения

ORDER BY ... LIMIT and JOIN  (Fizu, )
 Re: ORDER BY ... LIMIT and JOIN  (Michael Andreen, )
  Re: ORDER BY ... LIMIT and JOIN  (Fizu, )
   Re: ORDER BY ... LIMIT and JOIN  (Michael Andreen, )
   Re: ORDER BY ... LIMIT and JOIN  (Robert Haas, )

On Saturday 08 August 2009 08:02:47 Fizu wrote:
>                ->  Index Scan using country_ranking_user_idx on "user"
>  (cost=0.00..6.49 rows=1 width=145) (actual time=0.023..57.633
> rows=57309 loops=1)
>                      Index Cond: (country_id = 1)

The planner is expecting one user with country_id = 1, but instead there are
57309. Have you analyzed recently? Maybe increasing the statistics target will
help.

/Michael


В списке pgsql-performance по дате сообщения:

От: Bruce Momjian
Дата:
Сообщение: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance
От: Robert Haas
Дата:
Сообщение: Re: Need suggestions on kernel settings for dedicated FreeBSD/Postgresql machine