Question: What is the performance of a Postgres recursive query with a large depth on millions of rows? Should I use a graph database instead?

This page summarizes the projects mentioned and recommended in the original post on /r/Database

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

  • sqlraytracer

    Everyone writes a Raytracer eventually. This is mine.

    • The only thing that's awkward about postgres is that it is documented as fully materialising a recursive CTE before handing you any rows. If you have some truly offensively large graph traversal [output, not input], it can take a while to create the temp table. My sql raytracer can take minutes per image because of the gargantuan temp storage thing.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • A smaller YugabyteDB image for CI/CD

    1 project | dev.to | 27 Apr 2024

  • Pg_tier: Postgres Extension to enable data tiering to AWS S3

    1 project | news.ycombinator.com | 25 Apr 2024

  • Bloom Filter Indexes in PostgreSQL

    2 projects | news.ycombinator.com | 23 Apr 2024

  • Supabase Security Advisor & Performance Advisor

    2 projects | dev.to | 19 Apr 2024

  • From Postgres Proto to TypeScript – new transpiler for tooling

    2 projects | news.ycombinator.com | 31 Mar 2024