psqlodbc 07.03.0261 Memory Leak?
От | Daniel Holm |
---|---|
Тема | psqlodbc 07.03.0261 Memory Leak? |
Дата | |
Msg-id | 22CFEEFF5C5D60429D6B0572DB26625928FD79@iwsbsrv1.InterWorksok.com обсуждение исходный текст |
Список | pgsql-odbc |
I'm copying data from a table of over 100,000 rows in Microsoft SQL server. This table contains a column of type "Image". I am using a DTS package and have mapped that column over to a column of type "bytea". The stable 8.x driver won't even begin to copy the data, so I have attempted to use the experimental driver (07.03.0261) to do my copying. It works great, except for the excessive memory usage. The memory usage constantly climbs throughout the execution. I can run about 2000 rows quickly - then it slows down considerably (probably switches to using virtual memory). Around 7,000 rows it finally dies and prints this for the first error: "Query buffer allocate error in copy_statement_with_parameters" And then second: "Out of memory in PGAPI_PutData (3)" 1) Is there anything more I can provide to assist in locating the cause of this leak? 2) Is there a better way to transfer these 100,000 rows from Microsoft SQL to Postgres 8.1 instead of using a DTS package? The memory issue could be from there. Thanks in advance for any assistance; you all have been wonderful so far in this process! -Daniel Holm
В списке pgsql-odbc по дате отправления: