Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9EAE99F9ECF for ; Thu, 30 Nov 2006 14:43:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 66420-08 for ; Thu, 30 Nov 2006 14:43:12 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id 251BA9FA170 for ; Thu, 30 Nov 2006 14:43:12 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1982064ugf for ; Thu, 30 Nov 2006 10:43:12 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=cYQ5DckYN+0XwbDyhjG0XPNWO+kg5tgFuujNL4TwFchmdCs3t/3iztDtmpJNudbIlknCVaMJK7xHgnEp1V06ZNSdbr+Nqpi7whtmbMEcAYAXtgdUJHTkSe8HxJQ7L65dyM3Gpm8cKffD/ftqwo5Qkl2bCDOg0mqR7b3al6yLucU= Received: by 10.67.121.15 with SMTP id y15mr5862470ugm.1164912191531; Thu, 30 Nov 2006 10:43:11 -0800 (PST) Received: by 10.67.118.11 with HTTP; Thu, 30 Nov 2006 10:43:11 -0800 (PST) Message-ID: <55c095e90611301043h757013bdge082747b63329f5a@mail.gmail.com> Date: Thu, 30 Nov 2006 16:43:11 -0200 From: "Ezequias Rodrigues da Rocha" To: "Aaron Bono" Subject: Re: Select (1-3) Cc: pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <55c095e90611301030t6b380e64rc3b614acd5759297@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/302 X-Sequence-Number: 26954 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 : > On 11/30/06, Ezequias Rodrigues da Rocha wrote= : > > Hi list, > > > > It is possible to make a selection like > > > > Select (list 1 to 1000); > > > > And get the rows ? > > > > producao=3D# 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.ht= ml?page=3D2 > > -- > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Aaron Bono > Aranya Software Technologies, Inc. > http://www.aranya.com > http://codeelixir.com > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/