Greetings
Starting from version 12.0 official docker image switched from Debian-stretch
to Debian-bullseye and from that point we have a huge pain with sorting issues
on Russian collation.
Dockerfile:
FROM postgres:14
RUN apt-get clean && apt-get update && apt-get install -y locales
RUN locale
Greetings,
Didn’t get your ideas with materialized CTE or a subquery with OFFSET 0
Could you please show simple example?
> 23 февр. 2021 г., в 04:33, Michael Lewis написал(а):
>
> Insert the values into a TEMPORARY TABLE, then join that to your main table?
>
> In my experience, this is very
Greetings,
We have queries with IN filters with long list of INT values
Sometimes, they running extremely slow, and I have found suggestion to use
syntax
Field IN (VALUES(1465), (1478), ...
Instead of
Field IN (1465, 1478, ...
On some cases it helps, but on other it makes query running 1000+ ti
