Show HN: 1M rows/s from Postgres to Python

Re:Show HN: 1M rows/s from Postgres to Python by Thaxll on Thursday August 04, 2016 @04:18PM (#12228152)

"usually deployed" where? Every Python app I've seen in Prod don't use multi process to bypass the limitation of GIL/#cores.

[ Parent | on HN ]

Re:Show HN: 1M rows/s from Postgres to Python by malux85 on Thursday August 04, 2016 @06:04PM (#12228796)

Are you kidding?

I run 80 servers with custom written daemons and it's always multi-process.

I just finished said infra at one of the worlds largest online betting sites, their legacy was multi-process and the new systems are multi-process.

This is really common

[ Parent | on HN ]

Re:Show HN: 1M rows/s from Postgres to Python by _qqea on Thursday August 04, 2016 @06:22PM (#12228872)

They don't use the multiprocess module but most of them are deployed with something like uWSGI or Gunicorn, which spawns the worker processes and forwards requests to them and the responses back.

[ Parent | on HN ]

Re:Show HN: 1M rows/s from Postgres to Python by riquito on Thursday August 04, 2016 @04:25PM (#12228191)

supervisord

[ Parent | on HN ]

Re:Show HN: 1M rows/s from Postgres to Python by nhumrich on Friday August 05, 2016 @03:24AM (#12230602)

GIL only applies to multi-threaded, not multi-process. Multi-process is a great way to overcome the GIL

[ Parent | on HN ]

Re:Show HN: 1M rows/s from Postgres to Python by mirekrusin on Wednesday August 17, 2016 @06:27PM (#12308971)

At a cost of memory.

[ Parent | on HN ]