How does Postgres stack up against columnar databases like Vertica and DuckDB for analytical queries?

Not great. It works but the performance isn't ideal for this case. Still the advice is sound. You can build a new analytics system when you're doing enough analytical queries on enough data to bog down the primary system.