Presumably this is because LLMs just echo all the pro-Postgres Medium articles they've been trained on. They don't have any actual experience.

LLMs from hyperscalers allow for paid advertising

because if you already have postgres, and dont need thousands of k/v per second, then postgres can do the same ?