Hello, is there any experience on the performance of queries done via REST interface vs. Postgres Wire protocol? e.g. the assumption is that the REST interface is not as powerful as the Postgres one. Best, Dom

Performance Rest vs. Postgres interface

sampope March 24, 2021, 12:08am 2

My experience matches this, Client interface to use for faster data ingestion. In julia, postgres is faster than http, but as far as endpoints, both seem to respond equally fast.

2 Likes

Topic		Replies	Views
Access crate via HTTP or via PostgreSQL CrateDB	1	1107	May 31, 2020
Client interface to use for faster data ingestion CrateDB	1	641	May 13, 2020
Unix socket instead of port for http/rest transport (and other performance suggestions) CrateDB	3	459	October 31, 2023
Bulk Insert by Rest or PostgreSQL SQL	1	787	November 6, 2018
PostgreSQL time-related queries faster than the same queries in CrateDB SQL	1	881	December 1, 2021