| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | mauricio pullabuestan <jmauriciopb(at)yahoo(dot)es> |
| Cc: | Postgres ayuda <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: Optimizar Update |
| Date: | 2023-09-08 17:29:35 |
| Message-ID: | 202309081729.j5q6wz3m2w62@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
mauricio pullabuestan escribió:
> SET work_mem = '500MB';
> TRUNCATE item_bodega_pedidos_spp;
> COPY item_bodega_pedidos_spp FROM '/home/pasa_vfp_pg/bodega_migra.csv' DELIMITER ',' CSV HEADER;
Asegúrate de hacer un ANALYZE después de insertar los datos en esta
tabla.
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"It takes less than 2 seconds to get to 78% complete; that's a good sign.
A few seconds later it's at 90%, but it seems to have stuck there. Did
somebody make percentages logarithmic while I wasn't looking?"
http://smylers.hates-software.com/2005/09/08/1995c749.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mauricio pullabuestan | 2023-09-08 17:41:34 | Re: Optimizar Update |
| Previous Message | Alvaro Herrera | 2023-09-08 17:27:58 | Re: Optimizar Update |