On Thu, Jan 4, 2024 at 7:13 AM Jeff Janes wrote:
>
>
>> *1st time query executed with PARALLEL DEGREE 2 *
>> explain analyze select /*+* PARALLEL(A 2)* */ * from
>> test_compare_all_col_src1 A;
>>
>> QUERY PLAN
>>
>> ---
> *1st time query executed with PARALLEL DEGREE 2 *
> explain analyze select /*+* PARALLEL(A 2)* */ * from
> test_compare_all_col_src1 A;
> QUERY
> PLAN
>
> -
On Tue, 2 Jan 2024, 21:45 David G. Johnston,
wrote:
> On Tue, Jan 2, 2024 at 8:12 AM mohini mane
> wrote:
>
>>
>> I have executed the SELECT query with 2,4 & 6 parallel degree however
every time only 4 workers launched & there was a slight increase in
Execution time as well,
>>>
>
On Tue, Jan 2, 2024 at 8:12 AM mohini mane wrote:
>
> I have executed the SELECT query with 2,4 & 6 parallel degree however
>>> every time only 4 workers launched & there was a slight increase in
>>> Execution time as well,
>>>
>>
>> Adding an ignored comment to your SQL would not be expected to
On Fri, Dec 29, 2023 at 10:25 AM Jeff Janes wrote:
>
>
> 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
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 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
On Wed, Dec 27, 2023 at 8:15 AM mohini mane
wrote:
> Hello Team,
> I observed that increasing the degree of parallel hint in the SELECT
> query did not show performance improvements.
> Below are the details of sample execution with EXPLAIN ANALYZE
>
PostgreSQL doesn't have hints, unless you are
On 12/27/23 14:15, mohini mane wrote:
> Hello Team,
> I observed that increasing the degree of parallel hint* *in the SELECT
> query did not show performance improvements.
> Below are the details of sample execution with EXPLAIN ANALYZE
> *PostgreSQL Version:* v15.5
>
> *Operating System details:*
Hello Team,
I observed that increasing the degree of parallel hint in the SELECT query
did not show performance improvements.
Below are the details of sample execution with EXPLAIN ANALYZE
*PostgreSQL Version:* v15.5
*Operating System details:* RHL 7.x
Architecture: x86_64
CPU op-mode(s):
12 matches
Mail list logo
