X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A595BD1BAE7 for ; Thu, 4 Sep 2003 07:59:02 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 13221-01 for ; Thu, 4 Sep 2003 04:58:53 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 29D13D1B8F5 for ; Thu, 4 Sep 2003 04:58:51 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h8485LK8026414 for ; Thu, 4 Sep 2003 13:35:21 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h8485JCO026398 for ; Thu, 4 Sep 2003 13:35:19 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Thu, 04 Sep 2003 13:30:51 +0530 MIME-Version: 1.0 Subject: Re: SELECT's take a long time compared to other DBMS Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F573E8B.31916.A1063F8@localhost> In-reply-to: X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/55 X-Sequence-Number: 3421 On 4 Sep 2003 at 0:48, Relaxin wrote: > All of the databases that I tested the query against gave me immediate > access to ANY row of the resultset once the data had been returned. > Ex. If I'm currently at the first row and then wanted to goto the 100,000 > row, I would be there immediately, and if I wanted to then goto the 5 > row...same thing, I have the record immediately! > > The other databases I tested against stored the entire resultset on the > Server, I'm not sure what PG does...It seems that brings the entire > resultset client side. > If that is the case, how can I have PG store the resultset on the Server AND > still allow me immediate access to ANY row in the resultset? You can use a cursor and get only required rows. Bye Shridhar -- Nick the Greek's Law of Life: All things considered, life is 9 to 5 against.