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" -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
