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 04BE8329E84 for ; Tue, 12 Oct 2004 12:43:54 +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 78033-05 for ; Tue, 12 Oct 2004 11:43:42 +0000 (GMT) Received: from web54110.mail.yahoo.com (web54110.mail.yahoo.com [206.190.37.245]) by svr1.postgresql.org (Postfix) with SMTP id A7457329DB0 for ; Tue, 12 Oct 2004 12:43:43 +0100 (BST) Message-ID: <20041012114343.69531.qmail@web54110.mail.yahoo.com> Received: from [129.94.6.30] by web54110.mail.yahoo.com via HTTP; Tue, 12 Oct 2004 04:43:43 PDT Date: Tue, 12 Oct 2004 04:43:43 -0700 (PDT) From: my ho Subject: Re: execute cursor fetch To: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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/159 X-Sequence-Number: 8635 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