Can anyone comment on whether postgres can replace full columnar DB? I see "full text search" but it feels like this is falling a little short of the full power of elastic -- but would be happy to be wrong (one less tech to remember).
According to the LLM google search result, yes.
Have you looked into it?
There are several different plugins for postgres that do columnar tables, including the company TigerData which wrote this blog