Re: Parallel hints in PostgreSQL with consistent perfromance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 
1st time query executed with PARALLEL DEGREE 2 
explain analyze select /*+ PARALLEL(A 2) */ * from test_compare_all_col_src1 A;
                                                                     QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=10.00..45524.73 rows=949636 width=97) (actual time=0.673..173.017 rows=955000 loops=1)
   Workers Planned: 4
   Workers Launched: 4
   ->  Parallel Seq Scan on test_compare_all_col_src1 a  (cost=0.00..44565.09 rows=237409 width=97) (actual time=0.039..51.941 rows=191000 loops=5)
 Planning Time: 0.093 ms
 Execution Time: 209.745 ms
(6 rows)

Your alias is not enclosed in double quotes, so it is downcased to "a" (as can be seen from the alias printed in the plan).  But pg_hint_plan hints don't follow the downcasing convention, so the hint on "A" does not match the alias "a", and so is ignored.
 
Cheers,

Jeff

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux