moz escribió:
> select count(*) from clientes where rut = 1;
> Aggregate (cost=3659.27..3659.27 rows=1 width=0)
> -> Index Scan using k_rut on clientess (cost=0.00..3655.50 rows=1508
> width=0)
> Index Cond: (rut = 1)
>
> select * from clientes where rut = 1;
> Index Scan using k_rut on clientes (cost=0.00..3655.50 rows=1508 width=436)
> Index Cond: (rut = 1)
Vaya, por favor envia el EXPLAIN ANALYZE de estas dos consultas.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support