Re: joining two tables slow due to sequential scan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: joining two tables slow due to sequential scan
Дата
Msg-id 2937.1139611910@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: joining two tables slow due to sequential scan  ("Tim Jones" <TJones@optio.com>)
Список pgsql-performance
"Tim Jones" <TJones@optio.com> writes:
> QUERY PLAN
> 'Hash Join  (cost=899.83..4384.17 rows=482 width=1350) (actual
> time=0.203..0.203 rows=0 loops=1)'
> ...
> 'Total runtime: 0.392 ms'

Hardly seems like evidence of a performance problem ...

            regards, tom lane

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: joining two tables slow due to sequential scan
Следующее
От: "Tim Jones"
Дата:
Сообщение: Re: joining two tables slow due to sequential scan