From: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
To: Aaron Bono <postgresql@aranya.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Select (1-3)
Date: Thu, 30 Nov 2006 16:43:11 -0200
Message-ID: <55c095e90611301043h757013bdge082747b63329f5a@mail.gmail.com> (raw)
In-Reply-To: <bf05e51c0611301035l42fa2178n398c3fc2c281ead2@mail.gmail.com>
References: <55c095e90611301030t6b380e64rc3b614acd5759297@mail.gmail.com>
<bf05e51c0611301035l42fa2178n398c3fc2c281ead2@mail.gmail.com>
Uow !
1 to one m
select * from generate_series(1, 1000000);
In 5203 miliseconds (that's a great performmance). My server is not
quite good but the performance was great for me.
Thank you so much
Ezequias
2006/11/30, Aaron Bono <postgresql@aranya.com>:
> On 11/30/06, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> > Hi list,
> >
> > It is possible to make a selection like
> >
> > Select (list 1 to 1000);
> >
> > And get the rows ?
> >
> > producao=# select ...;
> > row
> > ---------
> > 1
> > 2
> > 3
> > .
> > .
> > .
> > 1000
> >
>
> select * from generate_series(1, 1000);
>
> See
> http://oreillynet.com/pub/a/databases/2006/09/07/plpgsql-batch-updates.html?page=2
>
> --
> ==================================================================
> Aaron Bono
> Aranya Software Technologies, Inc.
> http://www.aranya.com
> http://codeelixir.com
> ==================================================================
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
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: ezequias.rocha@gmail.com, postgresql@aranya.com
Subject: Re: Select (1-3)
In-Reply-To: <55c095e90611301043h757013bdge082747b63329f5a@mail.gmail.com>
* 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