---------- Forwarded message ---------- From: Sandrigo L.Jara <[EMAIL PROTECTED]> Date: 2008/6/29 Subject: indices To: [EMAIL PROTECTED], Grupo de Usuários do PostgreSQL no Brasil <[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.. Abraços a todos -- SANDRIGO L.JARA Gerencia de Projetos e Sistemas www.ogilvy.com & www.datasearch.com.br [EMAIL PROTECTED] Office: +55-11-3024 9005 Mobile: +55-11-8431-7739 Brasil - São Paulo
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral