Which is faster: data processing in pgsql or php?

Question

PHP

There are 2 tables with a huge amount of data (details, statistics). Is it worth it to join and write data processing and formatting in pgsql (so that the data is displayed directly on the site.)? or is it better to run foreach in php doing the same, but the select will be simple?
* it is worth considering that the processing will be quite complex, with mathematical functions, multiple concatenation and data transformation

Answer 1

As for data sampling without processing it, do it using simple postgre procedures. As
for business logic, write in the language in which it is easier to write tests . You
will have to rewrite the code several times, regardless of your qualifications.

Answer 2

Compile through c and run through sphenx) The speed will be ..)

Answer 3

postgres will be faster. IMHO.

Answer 4

compare

Answer 5

I have been dealing with this issue for a long time. As a result, I adopted the formula for myself: "simple SELECT + processing in the backend". Reasons:
1. More maintainable code - the execution logic is not scattered in two places, but all sits in the BackEnd
2. There were problems with warming up - it's easier to pull two tables separately than one through JOIN. It turns out faster on primary data access.
3. Easier debugging and bug fixing, easier functionality extension