Slacker News Slacker News logo featuring a lazy sloth with a folded newspaper hat
  • top
  • new
  • show
  • ask
  • jobs
Library
← Back to context

Comment by getnormality

5 hours ago

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

1 comment

getnormality

Reply

direwolf20  5 hours ago

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.

Slacker News

Product

  • API Reference
  • Hacker News RSS
  • Source on GitHub

Community

  • Support Ukraine
  • Equal Justice Initiative
  • GiveWell Charities