memory leak in v0.4.0 load data from postgres

[xma08]

What language are you using?

Python

What version are you using?

v0.4.0

What database are you using?

PostgreSQL

What dataframe are you using?

Pandas

Can you describe your bug?

A memory leak when upgrading version v0.3.3 to v.4.0 using the main API cx.read_sql loading from postgres to Pandas DataFrame

What are the steps to reproduce the behavior?

If possible, please include a minimal simple example including:

Example query / code

import connectorx as cx

sql = "select * from test_sample"
for _ in range(100):
    df = cx.read_sql("<conn string>", sql)

What is the error?

Running a simple query above over many iterations, the memory kept increasing. The issue was gone once rolling back to v0.3.3.

[wangxiaoying]

Hi @xma08 , thanks for reporting the issue!

Have you tested the last alpha release pip install connectorx==0.3.4a3 before v0.4.0? Just want to narrow down the possible causes for the leak.

[xma08]

Yes, just tried 0.3.4a3 and didn't find such issue.