Carlos Henrique Reimer <carlos.reimer@xxxxxxxxxxxxx> writes: > Will include the EXPLAIN ANALYZE again here: > -> Index Scan using pagpk_aux_mes, pagpk_aux_mes, pk_cadpag, pk_cadpag, > pk_cadpag, pagchavefunc00 on cadpag (cost=0.00..131521.88 rows=183322 > width=62) (actual time=0.664..614.080 rows=32828 loops=1) BTW, I just noticed this multiple-index annotation, which means that either you're not using a community version of Postgres or else it's 8.0 or older (8.1 replaced that plan type with bitmap index scans). In the latter case you'd be well advised to think about updating to something that hasn't been out of support for more than two years. In any case you're unlikely to get helpful advice when you fail to mention that you're using a dinosaur release. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
