Hi there, we're now using PGVectorStore

At a glance

The community member is using PGVectorStore and is seeing a lot of open connections to the Postgres database. They are unsure if they need to close the connections manually or if it's handled automatically. The comments suggest that the connections should be closed automatically using the with statement, similar to how files are closed automatically. However, the community members are still seeing warnings about open connections, so it seems there may be an issue with their custom code that is not properly closing the connections.

kkevingoed

Hi there, we're now using PGVectorStore and we're seeing that there's a lot of open connections to the postgres db. Do we need to close the connections somehow, has anyone every run into this issue?

8 comments

LLogan M

I think I've seen warning about it, but tbh I haven't dove into it yet lol

LLogan M

Not 100% sure how/where its happening

LLogan M

since all the db connections are scoped

LLogan M

Plain Text

with self._session() as session, session.begin():
    ...

kkevingoed

interesting, I'll have a look it might be some of our custom code 😄

kkevingoed

but good to know that you dont specifically have to close it.

LLogan M

Yea from my understanding, the with ... statement should be closing it

Similair to how with open("file.txt", 'r') as f: will close the file for you

LLogan M

(but clearly with the warnings being printed, it's maybe not happening somewhere lol)

Add a reply

Find answers from the community

Hi there, we're now using PGVectorStore