On 5 Mar 2010, at 11:28, John777 wrote:
> Hi,
>
> Here are sample stat:
> - Template_product has 1,033040 rows
> - template_all_in_one has 93,796,400 rows
>
> I basically need to calculate the total for each article in
> template_all_in_one and update it to Template_product.
>
> What is the bes
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)"
"-> Ag
Hi,
Here are sample stat:
- Template_product has 1,033040 rows
- template_all_in_one has 93,796,400 rows
I basically need to calculate the total for each article in
template_all_in_one and update it to Template_product.
What is the best way to improve the performance? I already have 7
indexes
