I have quite complicated query:
SELECT axis_x1, axis_y1, SUM(delivery_price) as v_1 FROM (
SELECT to_char(delivery_data.delivery_date, '-MM') as axis_x1,
clients.id_client as axis_y1, delivery_data.amount * production_price.price
* groups.discount as delivery_price
FROM delivery_data
JOIN cl
Thanks for suggestion
with tmp tables there are another issue - there are already 5-6 tables and
2-3 IN filters. If i will replace them with tmp tables it may hit query
planner limits and it will become to produce terrible query plans, for
example when genetic query optimizer starts
On Tue, Feb 2
Greetings,
i have tested both options ANY with string + parsing and simple array - and
there are cases when execution time 100+ times worse than IN
On Tue, Feb 23, 2021 at 12:23 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Monday, February 22, 2021, Oleksandr Voytsekhovskyy
>
