From: | Felipe de Jesús Molina Bravo <fjmolinabravo(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: query reboot pgsql 9.5.1 |
Date: | 2016-03-04 20:52:20 |
Message-ID: | CALrs2KP4ktGNGwzRw72uSmG5iOFH3GwYVfnJhmBKX4dGN_oB+Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>
>> Now i execute the same in pgsql 9.4.5 and all is fine!!!
>>
>> The EXPLAINs are:
>>
>> - pgsql 9.5.1:
>>
>> Nested Loop Left Join (cost=0.03..492944.81 rows=276095 width=4)
>> -> Seq Scan on _gc_tb a (cost=0.00..3321.30 rows=120130 width=66)
>> -> Bitmap Heap Scan on _gc_cat b (cost=0.03..4.06 rows=2
>> width=70)
>> Recheck Cond: ((arama <@ a.arama) AND (a.arama <@ arama))
>> -> Bitmap Index Scan on _gc_cat_arama_gin
>> (cost=0.00..0.03 rows=2 width=0)
>> Index Cond: ((arama <@ a.arama) AND
>> (a.arama <@ arama))
>>
>>
>> - pgsql 9.4.5:
>> Nested Loop Left Join (cost=0.03..492944.81 rows=276095 width=4)
>> -> Seq Scan on _gc_tb a (cost=0.00..3321.30 rows=120130 width=66)
>> -> Bitmap Heap Scan on _gc_cat b (cost=0.03..4.06 rows=2
>> width=70)
>> Recheck Cond: ((arama <@ a.arama) AND (a.arama <@ arama))
>> -> Bitmap Index Scan on _gc_cat_arama_gin
>> (cost=0.00..0.03 rows=2 width=0)
>> Index Cond: ((arama <@ a.arama) AND
>> (a.arama <@ arama))
>>
>
> The above are exactly the same, so if they are indeed from the different
> versions I do not see an issue. The question to ask here is whether the
> above are actually from the different Postgres instances?
>
>
yes these are differents
>
>
>>
> So is each Postgres instance running in a separate container and if so are
> they set up the same?
>
>
Yes, is the same configuration!!
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2016-03-04 21:00:20 | Re: query reboot pgsql 9.5.1 |
Previous Message | Adrian Klaver | 2016-03-04 20:42:30 | Re: query reboot pgsql 9.5.1 |