News for hackers. Stuff that matters.
Re:1.1B Taxi Rides on Kdb+/q and 4 Xeon Phi CPUs by juliangoldsmith on Wednesday January 25, 2017 @03:48PM (#13485911)
>Just because a relatively well-optimized PostgreSQL database on a regular workstation takes 5 minutes to run a query doesn't mean you can't get special hardware to run that query faster than you can type.

This is actually my biggest complaint with the article. He used cstore_fdw with Postgres, which doesn't allow much real indexing, and as far as I can tell (knowing only a little bit about it) he didn't really use any of the benefits of cstore_fdw.

I'd be interested to see how plain Postgres, possibly on a compressed filesystem, with properly-indexed tables stacks up.

There are no comments on this comment yet.