On Thu, Dec 28, 2023 at 7:47 AM mohini mane
wrote:
> Thank you for your response !!
> I am experimenting with SQL query performance for SELECT queries on large
> tables and I observed that changing/increasing the degree of parallel hint
> doesn't give the expected performance improvement.
>
But
On Thu, Dec 28, 2023 at 12:03 PM Darwin Correa wrote:
>
> when run the query (query.sql) as you can see in explain (plan4_v3.txt)
> citus take about 18s to run all fragments
>
Where is plan4_v3.txt? Is that hidden in some non-obvious way in one of
your links?
> but each fragment take at most
Hello great day, we have a strange case with slow query and would like some
help.
I've already read the article
https://wiki.postgresql.org/wiki/Slow_Query_Questions
Explain: https://paste.depesz.com/s/PLP
Explain2:
https://explain-postgresql.com/archive/explain/8e4b573c5f7bcf3a0d30675
On Thursday, December 28, 2023, mohini mane
wrote:
> Thank you for your response !!
> I am experimenting with SQL query performance for SELECT queries on large
> tables and I observed that changing/increasing the degree of parallel hint
> doesn't give the expected performance improvement.
>
> I h
On Thu, Dec 28, 2023 at 9:47 AM mohini mane
wrote:
> Thank you for your response !!
> I am experimenting with SQL query performance for SELECT queries on large
> tables and I observed that changing/increasing the degree of parallel hint
> doesn't give the expected performance improvement.
>
Why
Thank you for your response !!
I am experimenting with SQL query performance for SELECT queries on large
tables and I observed that changing/increasing the degree of parallel hint
doesn't give the expected performance improvement.
I have executed the SELECT query with 2,4 & 6 parallel degree howev
