Scalable Sequence for PostgreSQL

This page summarizes the projects mentioned and recommended in the original post on dev.to

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • FlexyPool

    FlexyPool adds metrics and failover strategies to a given Connection Pool, allowing it to resize on demand.

  • However, PostgreSQL caches the sequences per-connection (different from Oracle that caches in the instance shared memory). Sequences can be a bottleneck in case of a storm where all have a cold cache, and here is a workaround. Note that re-connecting in PostgreSQL is expensive for many reasons and better fixt that with a connection pool that is not too dynamic (if you need this, you should have a look at FlexiPool)

  • 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