Re: Optimize complex join to use where condition before

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Optimize complex join to use where condition before
Дата
Msg-id 8764xnoehv.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Optimize complex join to use where condition before  (Sebastian Hennebrueder <usenet@laliluna.de>)
Ответы Re: Optimize complex join to use where condition before
Список pgsql-performance
Sebastian Hennebrueder <usenet@laliluna.de> writes:

> User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
> ...
>
> "Nested Loop  (cost=1349.13..1435.29 rows=1 width=2541) (actual
> time=1640.000..3687.000 rows=62 loops=1)"
> "  Join Filter: ("inner".fid = "outer".faufgaben_id)"
> "  ->  Index Scan using idx_tauf_mit_mitid on taufgaben_mitarbeiter am
> (cost=0.00..80.65 rows=35 width=4) (actual time=0.000..0.000 rows=765
> loops=1)"

Is it really Mozilla Thunderbird that's causing this new craptastic mangling
of plans in people's mails? I was assuming it was some new idea of how to mess
up people's mail coming out of Exchange or Lotus or some other such "corporate
messaging" software that only handled SMTP mail as an afterthought. This is,
uh, disappointing.

--
greg

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

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Recommendations for set statistics
Следующее
От: "Mindaugas Riauba"
Дата:
Сообщение: PostgreSQL strugling during high load