News for hackers. Stuff that matters.

A comment on Async Python is not faster. Parent comment

Re:Async Python is not faster by fraggle222 on Friday June 12, 2020 @08:17AM (#23498462)
>Sidenote here: one thing I found but didn't mention (the reason I put in the pooling, both in Python and pgbouncer) is that otherwise, under load, the async implementions would flood postgres with open connections and everything would just break down.

Doesn't this prove that async is waiting for connections when you put a limit on it? The only way async wins is if it is free to hit the db whenever it needs to.

[ Parent | on HN ]
Re:Async Python is not faster by pas on Friday June 12, 2020 @10:14AM (#23499418)
But why async is spending so much CPU if it just waits?
[ Parent | on HN ]
Re:Async Python is not faster by fraggle222 on Friday June 12, 2020 @11:39AM (#23500316)
Who knows. The point is, if when not restricted you get a ton of db connections, then any restriction on that almost definitely means you are imposing a bottle neck. The only way this would not be the case is if it was trying to create db connections when it didn't need them, unlikely.
[ Parent | on HN ]