From: Sanketh Indarapu <sanketh_indarapu@yahoo.com>
To: pgsql-performance@postgresql.org
Cc: sanketh_indarapu@yahoo.com
Subject: Postgres odbc performance on windows
Date: Fri, 4 Feb 2005 11:29:36 -0800 (PST)
Message-ID: <20050204192937.55984.qmail@web53508.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sanketh_indarapu@yahoo.com
Subject: Re: Postgres odbc performance on windows
In-Reply-To: <20050204192937.55984.qmail@web53508.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox