From: Alvaro Herrera <alvherre@commandprompt.com>
To: Ezequias R. da Rocha <ezequias@fastcon.com.br>
Cc: pgsql-sql@postgresql.org
Subject: Re: For loop
Date: Tue, 13 Mar 2007 10:27:44 -0400
Message-ID: <20070313142744.GA7548@alvh.no-ip.org> (raw)
In-Reply-To: <45F6AF3B.4080706@fastcon.com.br>
References: <45F69D7C.4070304@fastcon.com.br>
<45F6B4EB.A3DD.0030.0@indicator.be>
<45F6A793.1090904@fastcon.com.br>
<200703130644.20870.aklaver@comcast.net>
<45F6AF3B.4080706@fastcon.com.br>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: alvherre@commandprompt.com, ezequias@fastcon.com.br
Subject: Re: For loop
In-Reply-To: <20070313142744.GA7548@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox