Ildarov Gazimagomed

I decided to compare clickhouse-go and pgx poolers by writing the [following](https://gist.github.com/threadedstream/c85722e27cd4fed87c56753a56c541ab) program. In pgx, I set the MaxConns value to 5, and it performs well even when there're 1000,...

@jkaflik exactly

@jkaflik In my production code, INSERT's happen more often relative to SELECT's. I'm aware that Clickhouse is not optimized for small insertions that happen frequently, that's why I'm inserting data...

Is there anything in later versions that optimizes overall pooler performance?

@jkaflik sure, here's my INSERT ```go withTimeoutCtx, cancel := context.WithTimeout(ctx, writeTimeout) defer cancel() batch, err := pool.PrepareBatch(withTimeoutCtx, query) if err != nil { return err } for i := 0;...

again, I don't think that not calling batch.Abort is the issue, as I had no troubles with batches for the last 2 days, so connection should be released, i.e returned...

@jkaflik could you please tell me how can I debug open connections? That is, find out what each connection is busy with at the moment. I assume it's not possible...