From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | "Ezequias R(dot) da Rocha" <ezequias(at)fastcon(dot)com(dot)br> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: For loop |
Date: | 2007-03-13 14:27:44 |
Message-ID: | 20070313142744.GA7548@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ezequias R. da Rocha | 2007-03-13 14:32:35 | Re: For loop |
Previous Message | Ezequias R. da Rocha | 2007-03-13 14:03:39 | Re: For loop |