Re: [GENERAL] Problem with collector statistic

Dear, Thanks, this solved my problem. I was using very low values for effective_cache_size. Thanks for your attention, Marco Aurélio V. da Silva Prodata Inf. e Cad. Ltda. MSN: [EMAIL PROTECTED] Fone: (33) 3322-3082 - Original Message - From: Scott Marlowe [EMAIL PROTECTED

[GENERAL] Problem with collector statistic

=1) - Index Scan using frete02_f021 on frete02 b (cost=0.00..4.65 rows=1 width=39) (actual time=0.021..0.024 rows=1 loops=9363) Index Cond: (outer.codpagador = b.codcliente) Total runtime: 551.331 ms Thanks to advance for your´s attention, Marco Aurélio V. da Silva Prodata

Re: [GENERAL] Problem with collector statistic

Scan using frete02_f021 on frete02 b (cost=0.00..4.65 rows=1 width=39) (actual time=0.163..0.166 rows=1 loops=9363) Index Cond: (outer.codpagador = b.codcliente) Total runtime: 1879.041 ms Thanks for your´s attention. Marco Aurélio V. da Silva Prodata Inf. e Cad. Ltda. MSN: [EMAIL