X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8828532A7BC for ; Tue, 12 Oct 2004 13:36:19 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91533-08 for ; Tue, 12 Oct 2004 12:36:10 +0000 (GMT) Received: from boutiquenumerique.com (gailleton-2-82-67-9-10.fbx.proxad.net [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 22A8732A486 for ; Tue, 12 Oct 2004 13:36:10 +0100 (BST) Received: (qmail 12858 invoked from network); 12 Oct 2004 14:36:10 +0200 Received: from unknown (HELO musicbox) (boutiquenumerique-lists@192.168.0.2) by gailleton-2-82-67-9-10.fbx.proxad.net with SMTP; 12 Oct 2004 14:36:10 +0200 To: "my ho" , pgsql-performance@postgresql.org Subject: Re: execute cursor fetch References: <20041012114343.69531.qmail@web54110.mail.yahoo.com> Message-ID: From: =?iso-8859-15?Q?Pierre-Fr=E9d=E9ric_Caillaud?= Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Date: Tue, 12 Oct 2004 14:36:10 +0200 In-Reply-To: <20041012114343.69531.qmail@web54110.mail.yahoo.com> User-Agent: Opera M2/7.54 (Linux, build 751) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/161 X-Sequence-Number: 8637 I just discovered this : http://www.postgresql.org/docs/7.4/static/jdbc-query.html#AEN24298 On Tue, 12 Oct 2004 04:43:43 -0700 (PDT), my ho wrote: > Hi, > If anyone can help pls, I have a question abt the > execution of cursor create/fetch/move , in particular > about disk cost. When a cursor is created, is the > whole table (with the required columns) got put into > memory? otherwise how does it work? (in term of disk > read and transfer?) after user issues command > move/fetch, how does postgre speed up the query in > compare to normal selection? > Thanks a lot, > regards, > MT Ho > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail Address AutoComplete - You start. We finish. > http://promotions.yahoo.com/new_mail > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >