Search code examples
httpnpgsqlcratecratedb

Accessing Cratedb via HTTP Endoint vs PostgreSQL Wire Protocol


I was wondering if anyone has tried comparing the speed in querying (lets just say any arbitrary query for this exercise) using either HTTP end point and the PostgreSQL connection to cratedb.

Considering what's under the hood is elastic search (lucene) engine which is HTTP based and Crate having its Postgresql spin.


Solution

  • I reached out to CrateIO and Peter from CrateIO confirmed that using HTTP would be faster than using PostrgreSQL