dudas de un insert

From: Nicolás Domínguez Florit <ndomin(at)rec(dot)unicen(dot)edu(dot)ar>
To: <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: dudas de un insert
Date: 2005-12-13 14:09:36
Message-ID: 185901c5ffee$d9d2fe30$ea84a8c0@Nico
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda


Tengo una senetencia sql como la siguiente:

INSERT INTO dh03 SELECT * FROM DHTEMP;
Query OK, 65066 rows affected (364,05 sec)

y dhtemp tiene aprox. 65000 filas. El insert me tarda en ejecutar 364
segundos!

Que se les ocurre para acelerar los inserts?

Muchas gracias.

Nicolas.

PD:Buscando en google encontre una pagina con algo que no se que tan cierto
sera (http://www.sambar.polie.nl/sqllite.htm):
Test 10: INSERTs from a SELECT
BEGIN;
INSERT INTO t1 SELECT * FROM t2;
INSERT INTO t2 SELECT * FROM t1;
COMMIT;
PostgreSQL: 54.822
MySQL: 1.512
SQLite 2.4: 4.423
SQLite 2.4 (nosync): 2.386

The poor performance of PostgreSQL in this case appears to be due to its
synchronous behavior. The CPU was mostly idle during the 55 second run.

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2005-12-13 14:16:04 Re: Dudas sobre Slony
Previous Message Jaime Casanova 2005-12-13 13:41:00 Re: Diferencia de fechas