nowfound

Life & fun · June 8, 2024

Pg_analytica – Speed up queries by exporting tables to columnar format

Postgres extension that speeds up analytics queries by upto 90% - sushrut141/pg_analytica

Pg_analytica – Speed up queries by exporting tables to columnar format launched on June 8, 2024 with 42 votes, #769 of 4,672 launches that month and more than 90% of that year's launches. The site was still online in September 2026, 2 years on.

Visit github.com ↗Alternativestop 16% of June 2024

In plain words

Pg_analytica is a tool for PostgreSQL users who want to improve query performance. It exports tables to a columnar format, which can accelerate analytical queries. The tool is available on GitHub and targets database administrators and developers working with PostgreSQL databases who need faster query execution on large datasets.

written from the facts on this page · September 2026

Does a similar job

all alternatives →
  • pg_flame – flamegraph visualizations of PostgreSQL query plans2019 · github.com · ▲321

    A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame

  • Hydra 1.0 – open-source column-oriented Postgres2023 · hydra-so.notion.site · ▲269

    hi hn, hydra ceo here hydra is an open source, column-oriented postgres. you can set up remarkably fast aggregates on your project in minutes to query billions of rows instantly. postgres is great, but aggregates can take minutes to hours to return results on large data sets. long-running analytical queries hog database resources and degrade performance. use hydra to run much faster analytics on postgres without making code changes. data is automatically loaded into columnar format and compressed. connect to hydra with your preferred postgres client (psql, dbeaver, etc). following 4 months…

  • HO
    Hydra - Open-Source Columnar Postgres2023 · hydra.so · ▲122

    hi hn, hydra ceo here hydra is an open-source extension that adds columnar tables to Postgres for efficient analytical reporting. With Hydra, you can analyze billions of rows instantly without changing code. demo video (5 min): https://youtu.be/1yzxgb0Oyrw github repo: https://github.com/hydradatabase/hydra For 1.0 GA release, aggregate queries are over *60% faster* than Hydra beta due to aggregate vectorization. Spatial indexes (gin, gist, spgist, and rum indexes) and pg_hint_plan are now enabled for performance optimization. postgres is great, but…

  • Pg_analytics – Speed Up Postgres Analytical Queries by 94x2024 · github.com · ▲8
  • pg_netstat, a Postgres extension to monitor database network traffic2022 · github.com · ▲158

    pg_netstat is a Postgres extension to monitor database network traffic. It uses libpcap to capture packets and aggregates at user-specified interval.

  • PgQueuer – Transform PostgreSQL into a Job Queue2024 · github.com · ▲376

    PgQueuer is a Python job queue that uses PostgreSQL for everything — queue storage, locking, notifications. No Redis, no RabbitMQ, no separate broker to operate. If your app already has Postgres, you already have the broker. After ~2 years and 26 minor releases, 1.0 ships today as the first stable release. Strict semver from here on. Thanks to everyone who contributed and left feedback!

More life & fun this month

the category →

Source: Show HN post ↗

Launched alongside, June 2024

the whole month →
  • Pygma▲1,412

    AI copilot for Instagram

    AI · 2024 · pygma.me

  • Cello▲1,347

    Easiest way to add a referral program to your SaaS

    Growth · 2024 · cello.so

  • La Growth Machine▲1,216

    Create personalized, multi-channel conversations at scale

    AI · 2024 · lagrowthmachine.com

  • Superhuman 2.0▲1,142

    Revolutionary AI email, reimagined for teams

    AI · 2024 · superhuman.com

  • FlowMapp 3.0▲1,142

    Visual website planning in the most powerful way

    Work · 2024 · flowmapp.com

  • PyjamaHR▲1,132

    Hiring on autopilot. The AI applicant tracking system (ATS).

    Work · 2024 · pyjamahr.com