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. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
