Re: For Loop using row_data to increase performance - Mailing list pgsql-general

here is the update section which take very long to run. ==>328001.274
ms
"Index Scan using idx_template_product on template_product
(cost=2729612.82..2729621.18 rows=1 width=87) (actual
time=327643.885..327643.889 rows=1 loops=1)"
"  Index Cond: (id = 10566)"
"  InitPlan 1 (returns $0)"
"    ->  Aggregate  (cost=2729612.81..2729612.82 rows=1 width=0)
(actual time=327643.769..327643.769 rows=1 loops=1)"
"          ->  Bitmap Heap Scan on template_all_in_one
(cost=604031.87..2693572.99 rows=14415929 width=0) (actual
time=94229.880..324091.136 rows=14753612 loops=1)"
"                Recheck Cond: (template_article_name =
'aname'::text)"
"                ->  Bitmap Index Scan on
idx_template_article_name_all_in_one  (cost=0.00..600427.89
rows=14415929 width=0) (actual time=94209.983..94209.983 rows=14753617
loops=1)"
"                      Index Cond: (template_article_name =
'aname'::text)"
"Total runtime: 328001.274 ms"