2008/6/29 Sandrigo L.Jara <[EMAIL PROTECTED]>: > > migrei 22 milhoes de registros em uma tabela no PostgreSQL 8.2 > ddds, numeros..etc ..ddds do tipo: character varying(3) > que quando executo: > > -- sem indices > -- Executing query: > SELECT ddd, count(ddd) AS qtde FROM tabela GROUP BY 1 ORDER BY 1 > Total query runtime: 432421 ms. > 65 rows retrieved. > > -- Executing query: > CREATE INDEX tabela_idx_ddd ON tabela (ddd) > Query returned successfully with no result in 496755 ms. > > novamente agora ja com indice... > > -- Executing query: > SELECT ddd, count(ddd) AS qtde FROM tabela GROUP BY 1 ORDER BY 1 > Total query runtime: 404579 ms. > 65 rows retrieved. > > ache q ia ser mais rapido > agradeço as dicas.. >
Sadrino, o capítulo 13 do manual aborda didaticamente este assunto, veja: http://pgdocptbr.sourceforge.net/pg80/performance-tips.html -- Ribamar FS - [EMAIL PROTECTED] http://ribafs.net
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral