s.
In turn, each month received the partitions per corresponding day.
That way, the planner needs to go through far fewer partitions to execute
the plan.
My planning time has dramatically reduced from 15s to 150ms.
Regards,
Sanyo Moura
Em qua, 28 de nov de 2018 às 23:01, Sanyo Moura
escreveu:
Em qua, 28 de nov de 2018 às 22:40, Justin Pryzby
escreveu:
> On Wed, Nov 28, 2018 at 05:03:15PM +1300, David Rowley wrote:
> > On Wed, 28 Nov 2018 at 03:16, Sanyo Moura wrote:
> > > 11.0
> > > Planning Time: 7.238 ms
> > > Planning Time: 2.638 ms
> > &
it has to do with a large number of partitions in a table.
Sanyo
Em ter, 27 de nov de 2018 às 23:27, Justin Pryzby
escreveu:
> On Tue, Nov 27, 2018 at 06:44:02PM -0600, Justin Pryzby wrote:
> > On Tue, Nov 27, 2018 at 9:17 AM Sanyo Moura
> wrote:
> > >>> I'm run
, Justin Pryzby
escreveu:
> On Tue, Nov 27, 2018 at 9:17 AM Sanyo Moura wrote:
> >>> I'm running performance tests for my application at version 11.1 and
> >>> encountered queries with high planning time compared to the same
> planning,
> >>> runni
2018 às 17:35, Jeff Janes
escreveu:
>
>
> On Tue, Nov 27, 2018 at 9:17 AM Sanyo Moura 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 plann
t; On Tue, Nov 27, 2018 at 9:17 AM Sanyo Moura 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.
, Tom Lane escreveu:
> Sanyo Moura writes:
> > And below are the times generated by EXPLAIN ANALYZE:
>
> > 10.5
> > Planning time: 126.080 ms
> > Execution time: 2.306 ms
>
> > 11.0
> > Planning Time: 7.238 ms
> > Planning Time: 2.638 ms
>
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.
-- Day and store where the highest price variation of a given product
occurred in a given period
explain analyze s
