Re:Costs of a PostgreSQL connection
by tbarbugli on Wednesday February 19, 2014 @11:50AM
(#7264508)
there are a number of applications that are sane and dont have a postgresql connection pooling built-in (eg. django introduced it on 1.6)
[ Parent
| on HN ]
Re:Costs of a PostgreSQL connection
by marcosdumay on Wednesday February 19, 2014 @05:12PM
(#7266657)
Django connections to the database are bounded by the number of threads and processess you set.
It didn't have a pool, but it's a mistake to think it just oppened connections at will.
Re:Costs of a PostgreSQL connection
by nousernamesleft on Wednesday February 19, 2014 @01:04PM
(#7265014)
Django requires multiple processes, which makes sharing things like connections quite difficult. That is not sane.
whats your alternative to that?
Re:Costs of a PostgreSQL connection
by nousernamesleft on Wednesday February 19, 2014 @01:52PM
(#7265356)
A language without a global lock to make threads useless.
You have taken a FUD sound bite and repeated it without understanding. The language is not at issue here. CPython's GIL does not make threads useless at all, and there are already Python interpreters without a GIL anyway.
An addiction to globally shared state across threads multiplies race conditions and scaling problems, even if the GIL magically goes away. If you are incapable of using even processes effectively then I really fear for you when you have to scale out horizontally.
I'd say this more nicely if I could think of any way, but you don't know what you're talking about and you should read up before you begin talking about it again. It looks bad and you might mislead someone.
Re:Costs of a PostgreSQL connection
by nousernamesleft on Wednesday February 19, 2014 @07:00PM
(#7267636)
No, you have taken a "stick my head in the sand and pretend the last 30 years of progress didn't happen" and repeating it without understanding. I do web development in haskell. I have thousands of concurrent connections to a single process, which is using 32 cores without problems. There has not been a single race condition, deadlock, mutex bottleneck, etc, etc. Just because you are happy with an absurdly primitive language, doesn't mean those of us in the 21st century are ignorant.