Viewing profile — ftisiot

Hi! Thanks for checking out! The issue should be resolved now

first run! I just rerun the experiment: - ~46 secs on the first run - ~22 secs on the following runs

The loading time it's included in both examples In the first one, the table is dropped, recreated, populated and queries. In the second example, the table is created from a file FD…

Just modified the original post to add the file_fdw. Again, none of the instances (PG or ClickHouse) were optimised for the workload https://ftisiot.net/posts/1brows/

Making robust and future-proof decisions about your data setup can be complex. The SOFT methodology is here to guide you to the right choices for your needs.

Parsing semi-structured dataset in a relational database seems scary. Read on for how PostgreSQL® JSON functions allow your SQL queries to work with json and jsonb data.

Integrate Apache Kafka with your existing PostgreSQL Database with Kafka Connect JDBC source connector