Jelte Fennema-Nio
Jelte Fennema-Nio
Can you run this command to see the number of open files per process? ``` lsof | cut -d ' ' -f1 | sort | uniq -c | sort -n...
Okay, so yeah those ~400 file descriptors for pgbouncer itself seem quite normal. Why postgres has so many open is probably because you have set: ``` max_files_per_process: 4096 ``` So...
> To be sure, when a client connect to pgbouncer -> create/reuse a pool connection that connect to postgres -> create a postgres process and this process can create /...
It's a "feature": https://github.com/uncrustify/uncrustify/blob/947897880b6c14411e221d0b58e37571681c92eb/src/align_stack.cpp#L161-L169 But it sounds good tot at least make this configurable
Removing that check causes the IMHO expected behavior btw.
Hmm, that does not seem good. Is this query latency of connection latency?
Second question: Did you compare logs for any differences that could explain the performance difference? e.g. warnings being shown, or new logs types of logs that are not there when...
> I could try enabling higher verbosity, do you think that would help diagnose? (setting verbose=2 I'm guessing) Yeah, that would probably be helpful. (no need to run this long)...
Okay, me and @emelsimsek tried a few things to reproduce this using pgbench in our own environments. But we were unable to. One of the many commands we tried was:...
Also, if you're able to create a small code sample/command that reproduces the performance issue for you that would help a lot, maybe a simple Django app or something. It's...