On 11/12/24 21:37, Tom Lane wrote:
Achilleas Mantzios writes:
Our sysadm created the system debian Debian GNU/Linux 12 (bookworm)with
postgres as user 1000. Now at some point we realized that whenever we
run a pgsql cluster with another user (I found that after spending two
good days testing)
On 11/12/24 20:37, Tom Lane wrote:
> Achilleas Mantzios writes:
>> Our sysadm created the system debian Debian GNU/Linux 12 (bookworm)with
>> postgres as user 1000. Now at some point we realized that whenever we
>> run a pgsql cluster with another user (I found that after spending two
>> goo
Achilleas Mantzios writes:
> Our sysadm created the system debian Debian GNU/Linux 12 (bookworm)with
> postgres as user 1000. Now at some point we realized that whenever we
> run a pgsql cluster with another user (I found that after spending two
> good days testing), the above query runs in abo
Στις 12/11/24 15:17, ο/η Tomas Vondra έγραψε:
On 11/12/24 11:37, Achilleas Mantzios - cloud wrote:
...
We run perf on both systems for 90 seconds to make sure that it included
at least two runs of the slow system, and we attach both outputs. We run
perf as :
sudo perf record -g -p -- sleep 9
On 11/12/24 11:37, Achilleas Mantzios - cloud wrote:
>
> ...
>
> We run perf on both systems for 90 seconds to make sure that it included
> at least two runs of the slow system, and we attach both outputs. We run
> perf as :
>
> sudo perf record -g -p -- sleep 90
>
> it strikes me that we dont
On 11/11/24 17:49, Ba Jinsheng wrote:
>It is all the time a challenge for PostgreSQL to estimate such a filter
>because of absent information on joint column distribution.
>Can you research this way by building extended statistics on these
>clauses? It could move the plan to the more optimal
