From: | Sanyo Moura <sanyo(dot)moura(at)tatic(dot)net> |
---|---|
To: | jeff(dot)janes(at)gmail(dot)com |
Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 |
Date: | 2018-11-27 20:20:21 |
Message-ID: | CAO698qYiH9L+gFk=i+pRDrBNLYF5wyUiF=Jt8uwEYCbCefE4Qg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
Hello Jeff,
My table (PRICE) is partitioned and contains 730 partitions. Each partition
contains 1 day of data.
I performed the same test now with restriction (WHERE) in only 1 day (1
partition), but doing SELECT in the virtual table PRICE.
I got the same delay in planning.
However, when I changed my query to use the partition directly, the plan
ran instantaneously.
I believe the problem should be in some internal code related to scanning
the partitions for the planning.
Does it make sense?
Thanks,
Sanyo Capobiango
Em ter, 27 de nov de 2018 às 17:35, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
escreveu:
>
>
> On Tue, Nov 27, 2018 at 9:17 AM Sanyo Moura <sanyo(dot)moura(at)tatic(dot)net> wrote:
>
>> Hi,
>>
>> I'm running performance tests for my application at version 11.1 and
>> encountered
>> queries with high planning time compared to the same planning, running at
>> versions 10.5 and 11.0.
>>
>
> Can you reproduce the regression if the tables are empty? If so, can you
> share the create script that creates the tables?
>
> Cheers,
>
> Jeff
>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Sanyo Moura | 2018-11-27 20:30:04 | Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 |
Previous Message | Jeff Janes | 2018-11-27 19:34:53 | Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 |
From | Date | Subject | |
---|---|---|---|
Next Message | Sanyo Moura | 2018-11-27 20:30:04 | Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 |
Previous Message | Jeff Janes | 2018-11-27 19:34:53 | Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 |