Postgres Pro
Downloads
Home   >   mailing lists

Re: Merge join vs merge semi join against primary key - Mailing list pgsql-general

From Jeremy Harris
Subject Re: Merge join vs merge semi join against primary key
Date
Msg-id 5619220B.4030008@wizmail.org
Whole thread Raw
In response to Merge join vs merge semi join against primary key  (Sean Rhea <sean.c.rhea@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Drop or alter column under load give ERROR #42804 structure of query does not match function result type:
Next
From: "Steve Petrie, P.Eng."
Date:
Subject: *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?