SET enable_indexscan TO OFF; SET EXPLAIN ANALYZE SELECT ani from trx_8 group by ani; QUERY PLAN -------------------------------------------------------------------------------------------------------------------- HashAggregate (cost=8668.54..8668.56 rows=2 width=8) (actual time=1658.423..1658.427 rows=2 loops=1) -> Seq Scan on trx_8 (cost=0.00..7778.83 rows=355883 width=8) (actual time=0.011..728.418 rows=355883 loops=1) Total runtime: 1658.680 ms (3 rows)
No veo diferencia. 2009/8/27 Jaime Casanova <jcasa...@systemguards.com.ec> > SET enable_indexscan TO OFF; -- Sebastian Machuca Estudiante IngenierÃa Civil en Computación +56 9 77449117 Sent from Providencia, RM, Chile