From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | Felipe de Jesús Molina Bravo <fjmolinabravo(at)gmail(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: query reboot pgsql 9.5.1 |
Date: | 2016-03-04 21:00:20 |
Message-ID: | CANu8Fiy=8yThGY6xoFuS+z00VFzVT7GFLVU+U+30drEugOYkvg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Mar 4, 2016 at 3:52 PM, Felipe de Jesús Molina Bravo <
fjmolinabravo(at)gmail(dot)com> wrote:
>
>
>>> 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!!
>
>>
>>
>
I suspect your 9.5.1 database has not been analyzed yet and therefore the
statistics are off.
Do the following in the 9.5.1 database and then retry your query.
ANALYZE VERBOSE public._gc_cat;
ANALYZE VERBOSE public._gc_tb;
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-03-04 21:01:15 | Re: query reboot pgsql 9.5.1 |
Previous Message | Felipe de Jesús Molina Bravo | 2016-03-04 20:52:20 | Re: query reboot pgsql 9.5.1 |