10,000x Speedup for Postgres Queries: How to Make a Smart Optimizer More Stupid

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

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

  • pg_hint_plan

    Extension adding support for optimizer hints in PostgreSQL

    • I really wish the PostgreSQL core team would acknowledge that their stance on that hurts more than helps. Even Oracle with decades of engineering behind it doesn't get execution plans correct 100% of the time and provides a way to tune query execution via hints.

    However, TIL that https://github.com/ossc-db/pg_hint_plan exists so that will probably become a standard thing I deploy.

  • 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

  • Hacking on PostgreSQL Is Hard

    2 projects | news.ycombinator.com | 5 May 2024

  • Automated integer hash function discovery

    11 projects | news.ycombinator.com | 4 May 2024

  • Drink Me: (Ab)Using a LLM to Compress Text

    1 project | news.ycombinator.com | 4 May 2024

  • Linux安装最新版Tinyproxy

    1 project | dev.to | 4 May 2024

  • PoC to demonstrate root permission hijacking by exploiting "systemd-run"

    2 projects | news.ycombinator.com | 4 May 2024