PGBouncer logs explanation required

[Shubham Mittal]

Hi Team,

I get below logs in pgbouncer.. when I configure query timeout in spring
boot application as below:

SessionImplementor session = entityManager.unwrap(SessionImplementor.class);
Connection connection = session.connection();
connection.createStatement().execute("SET LOCAL statement_timeout TO "
+ queryTimeOut);

2021-11-25 14:45:45.244 IST [18307] LOG C-0x6ae270: sit/postgres@abcdlogin
attempt: db=sit user=postgres tls=no
2021-11-25 14:45:45.299 IST [18307] LOG S-0x6b4f48: sit/postgres@abcd new
connection to server (from abcd)
2021-11-25 14:46:17.843 IST [18307] LOG S-0x6b4d10: sit/postgres@abcd *closing
because: query timeout (age=185s)*
2021-11-25 14:46:17.843 IST [18307] LOG C-0x6ae038: sit/postgres@abcd *closing
because: query timeout (age=185s)*
2021-11-25 14:46:17.843 IST [18307] WARNING C-0x6ae038: sit/postgres@*abcd
pooler error: query timeout*
2021-11-25 14:46:25.763 IST [18307] LOG stats: 0 xacts/s, 0 queries/s, in
30 B/s, out 141 B/s, xact 3660 us, query 4362 us, wait 152 us

Does this log mean that connection is closed and returned to the pool and
can be reused again?? Or something else?? Please help.

RE: Best Strategy for Large Number of Images

[Zahir Lalani]

Confidential

We have a large B2B application used in marketing management – heavily focused 
on images/video – no binaries ever stored in DB – we have all the metadata in 
the DB and binaries in scalable folder structure. Serving up images from the DB 
is not very scalable. I am not sure what you will do with the binary data that 
it is needed in the DB?

Z

From: Estevan Rech 
Sent: 15 December 2021 17:45
To: pgsql-general@lists.postgresql.org
Subject: Best Strategy for Large Number of Images

Hi,

I don't currently use PostgreSQL, but I plan to migrate and I have a question 
about the best way/strategy for storing images. I have about 2 million images 
with a growth trend of around 1 million images per year. I plan to store in 
bytea format in an isolated table. Is this recommended? Is there another better 
way?