Re: *very* inefficient choice made by the planner (regarding IN(...))

От: Tom Lane
Тема: Re: *very* inefficient choice made by the planner (regarding IN(...))
Дата: ,
Msg-id: 24880.1086880775@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: *very* inefficient choice made by the planner (regarding IN(...))  (Frank van Vugt)
Ответы: Re: *very* inefficient choice made by the planner (regarding IN(...))  (Frank van Vugt)
Список: pgsql-performance

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

*very* inefficient choice made by the planner (regarding IN(...))  (Frank van Vugt, )
 Re: *very* inefficient choice made by the planner (regarding  (Stephan Szabo, )
 Re: *very* inefficient choice made by the planner (regarding IN(...))  (Tom Lane, )
  Re: *very* inefficient choice made by the planner (regarding IN(...))  (Frank van Vugt, )
 Re: *very* inefficient choice made by the planner (regarding  (Jean-Luc Lachance, )
  Re: *very* inefficient choice made by the planner (regarding  (Tom Lane, )
   Re: *very* inefficient choice made by the planner (regarding  (Jean-Luc Lachance, )
    Re: *very* inefficient choice made by the planner (regarding  (Stephan Szabo, )
     Re: *very* inefficient choice made by the planner (regarding  (Stephan Szabo, )
 Re: *very* inefficient choice made by the planner (regarding  (SZUCS Gábor, )
  Re: *very* inefficient choice made by the planner (regarding  (Tom Lane, )
  Re: *very* inefficient choice made by the planner (regarding  (Stephan Szabo, )

Frank van Vugt <> writes:
> What could I do to make it easier to choose a better plan?

Increase sort_mem.  You want it to pick a "hashed subplan", but
it's not doing so because 64000 rows won't fit in the default
sort_mem.

            regards, tom lane


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

От: Stephan Szabo
Дата:
Сообщение: Re: *very* inefficient choice made by the planner (regarding
От: Nick Trainor
Дата:
Сообщение: ORDER BY user defined function performance issues