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 BB21B8B9DFA for ; Fri, 4 Feb 2005 19:29:43 +0000 (GMT) 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 40860-08 for ; Fri, 4 Feb 2005 19:29:37 +0000 (GMT) Received: from web53508.mail.yahoo.com (web53508.mail.yahoo.com [206.190.37.69]) by svr1.postgresql.org (Postfix) with SMTP id 83EA58B9D10 for ; Fri, 4 Feb 2005 19:29:37 +0000 (GMT) Received: (qmail 55986 invoked by uid 60001); 4 Feb 2005 19:29:37 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=QWPVXp+d7WOBhZyuPLEuqFBAwqViSh2ZidDQ7iotKvuMbOHcDVMU68t3sHR7YxpqaCeypJXWRzA9ks5Wx532AdqFGIZeVrKGBULh7JgugWYojBJUN9iMGuqGmBOe1F7fa8tppCaQ1iLQXcH1x9NMRnSOCLPM3gIzS3J2Rj8Z3O0= ; Message-ID: <20050204192937.55984.qmail@web53508.mail.yahoo.com> Received: from [146.6.92.192] by web53508.mail.yahoo.com via HTTP; Fri, 04 Feb 2005 11:29:36 PST Date: Fri, 4 Feb 2005 11:29:36 -0800 (PST) From: Sanketh Indarapu Subject: Postgres odbc performance on windows To: pgsql-performance@postgresql.org Cc: sanketh_indarapu@yahoo.com 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.374 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200502/131 X-Sequence-Number: 10460 Hi all, I am using a (MFC based) recordset to read in 25M records of a table. I use a cursor to prevent complete loading of all records. However, currently performance is limited by the number of times the odbc driver loads in the rows. The tuple cache is set to 5M. I am unable to increase it beyond this owing to "out of memory for tuple cache". This is not because of my RAM because there is atleast 1G of free RAM. Any ideas? This is on Windows, Postgresql 8.0. Please make sure to reply-all as I am not subscribed to the list. - Sanketh __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com