Hacker News new | past | comments | ask | show | jobs | submit | freeest-will's comments login

Careful with DISTINCT ON, it can be extremely slow, like 100x slower than a verbose and less readable alternative. But it might not matter in your use case.


I don't belive this is correct for postgres. It's true for other RDBMS, I believe. <https://medium.com/@smitagudale712/distinct-vs-group-by-in-s...>


I encountered this problem in Postgres 13.

https://blog.timescale.com/blog/how-we-made-distinct-queries...


A hand-written loose index scan sometimes helps in a case like this. I think it's not built-in yet.


> For example, in the COVID-19 vaccine developed by the University of Oxford, the control group receives a meningitis and septicaemia vaccine as a placebo.

> The benefit of using an actual vaccine as the placebo control is that it will cause a similar reaction at the site of the injection as the COVID-19 vaccine, such as muscle pain and soreness. This prevents patients from knowing whether they are getting the placebo or the real treatment.

https://theconversation.com/coronavirus-vaccine-why-its-impo...


Thank you.


Our current understanding of physics leaves no place for free will. Of course, many disagree with this.

https://physicsworld.com/a/why-free-will-is-beyond-physics/

https://aeon.co/essays/heres-why-so-many-physicists-are-wron...


Leaves no room for free will? We literally assume axiomatically experimenters freedom.

Since when is superdeterminism a done deal?

Conway had a few interesting words on this topic: https://en.m.wikipedia.org/wiki/Free_will_theorem


We know our knowledge of physics is incomplete.

There is no largely accepted obvious place where free will emerges from, while at the same time superdeterminism is not proven as you say.

So it's fair for some to say that physics as we know it doesn't allow free will, while at the same time it's fair for others to say that obviously they have free will thus it must exist.


"physics as we know it doesn't allow free will"

How?


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: