I rewritte the Jonah's function to:
FOR iter IN 1 .. num_iter
LOOP
-- some computations
INSERT INTO carga (descricao) VALUES ('CardPass');
END LOOP;
My ID is now() by default
And it was in 23sec
After I changed the insert to:
INSERT INTO carga (id,descricao) VALUES ('2007-03-13
10:20:20','CardPass');
And it was in:
19485ms
Great don't you ?
Ezequias
Alvaro Herrera escreveu:
Ezequias R. da Rocha wrote:
Thank you all. The function from Jonah solves my problem.
Just a simple question:
One million of inserctions in *28,8* seconds with this kind of data
(timestamp|character varring (50)) is a good performance ?
I let my questions to DBAs from PostgreSQL.
I don't know, but Jonah's function can be better written using pure SQL,
which should be faster. Something like this:
create table whatever (a text, b int);
insert into whatever
select 'My text from iteration ' || a, a * 2
from generate_series(1, 1000000) a;
I don't claim this works as is, but you should get the hang of it.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
