Re: Merge join vs merge semi join against primary key

Поиск
Список
Период
Сортировка
От Jeremy Harris
Тема Re: Merge join vs merge semi join against primary key
Дата
Msg-id 5619220B.4030008@wizmail.org
обсуждение исходный текст
Ответ на Merge join vs merge semi join against primary key  (Sean Rhea <sean.c.rhea@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On 09/10/15 20:52, Sean Rhea wrote:
[...]
>    ->  Index Scan using customers_pkey on customers  (cost=0.00..64192.97
> rows=184 width=8) (actual time=103.354..126.459 rows=359 loops=1)
>          Filter: (group_id = 45)
>          Rows Removed by Filter: 141684
>  Total runtime: 146.659 ms
[...]
>    ->  Index Scan using customers_pkey on customers o  (cost=0.00..63836.61
> rows=836 width=8) (actual time=159.840..201915.765 rows=7672 loops=1)
>          Filter: (group_id = 45)
>          Rows Removed by Filter: 212699113
>  Total runtime: 201995.044 ms

Are you sure the customers table was the same?
--
Jeremy

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Drop or alter column under load give ERROR #42804 structure of query does not match function result type:
Следующее
От: "Steve Petrie, P.Eng."
Дата:
Сообщение: *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?