rapphil | 11 months ago | on: I'm the Canadian who was detained by ICE for two weeks
rapphil's comments
rapphil | 1 year ago | on: Prometheus 3.0
rapphil | 2 years ago | on: Former intel officer says 'non-human biologics’ found at alleged UFO crash sites
rapphil | 3 years ago | on: Microsoft needs a search deal with Apple to win the war against Google
rapphil | 3 years ago | on: Ask HN: How did you stop drinking?
rapphil | 3 years ago | on: Firefox is losing users fast
rapphil | 3 years ago | on: Tesla’s ‘phantom braking’ problem is getting worse
rapphil | 3 years ago | on: Ask HN: What are examples of startups that died by the hands of Big Tech?
rapphil | 4 years ago | on: “You don't need this overengineered goo for your project.”
rapphil | 5 years ago | on: We Can’t Allow Big Tech to Exploit Coronavirus
rapphil | 6 years ago | on: Coronavirus: ‘strange pneumonia’ seen in Lombardy in Nov, says Italian doctor
rapphil | 6 years ago | on: Ask HN: Will the homeless with drug addiction go cold turkey during covid19?
rapphil | 6 years ago | on: Chinese scientists destroyed proof of virus in December?
rapphil | 6 years ago | on: Ask HN: What's your latest failed side project and why?
rapphil | 6 years ago | on: Maximizing Income as a Software Engineer
rapphil | 6 years ago | on: Ask HN: Joining Big Tech in One’s 40s
rapphil | 6 years ago | on: Ask HN: What Technologies to Learn in 2020?
I love Postgres.
rapphil | 6 years ago | on: Ask HN: 120M rows Postgres – how can I speed up queries?
https://pgtune.leopard.in.ua/#/
Are you monitoring your machine to check if it is not starving on cpu?
Re the queries, we have been using pgbadger to collect metrics about the usage of the dB and the slowest queries by type. This is helpful as it guides where you should put your efforts.
https://github.com/darold/pgbadger/blob/master/README.md
This is very good ref about scaling Postgres.
https://pyvideo.org/pycon-ca-2017/postgres-at-any-scale.html
rapphil | 6 years ago | on: Ask HN: Recommended resources to learn the Linux kernel and OS theory?
Not sure if they are accepting new applicants, but you can try. Also, you can try to find the assignments online.
rapphil | 6 years ago | on: Ask HN: What are you learning in 2019?