Postgres odbc performance on windows

Поиск
Список
Период
Сортировка
От Sanketh Indarapu
Тема Postgres odbc performance on windows
Дата
Msg-id 20050204192937.55984.qmail@web53508.mail.yahoo.com
обсуждение исходный текст
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
Дата:
Сообщение: Re: query produces 1 GB temp file
Следующее
От: Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
Дата:
Сообщение: Re: query produces 1 GB temp file