From: | "Sandrigo L(dot)Jara" <sandrigo(dot)lezcano(at)gmail(dot)com> |
---|---|
To: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | indices |
Date: | 2008-06-30 00:37:10 |
Message-ID: | 1a5d58e60806291737q6bcf1d7cn3ad03336b82184f9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
migre 22 millones de registros en una tabla en PostgreSQL 8.2
ddds, numeros..etc ..ddds del tipo: character varying(3)
que quando ejecuto:
-- sin indices
-- Executing query:
SELECT ddd, count(ddd) AS cantidad FROM tabla GROUP BY 1 ORDER BY 1
Total query runtime: 432421 ms.
65 rows retrieved.
-- Executing query:
CREATE INDEX tabla_idx_ddd ON tabla (ddd)
Query returned successfully with no result in 496755 ms.
nuevamente ahora ya con indice...
-- Executing query:
SELECT ddd, count(ddd) AS cantidad FROM tabla GROUP BY 1 ORDER BY 1
Total query runtime: 404579 ms.
65 rows retrieved.
deberia ser mucho!!!! mas rapido.. no???
agradezco todas las sugerencias
Abrazos a todos
From | Date | Subject | |
---|---|---|---|
Next Message | Pablo Marrero | 2008-06-30 00:53:25 | Re: indices |
Previous Message | Juan Carlos Badillo Goy | 2008-06-30 00:24:42 | Re: [OT] Cubanos en la lista |