news
PostgreSQL Coverage and pgCompare Community v1.0.0 Released
-
Shayon Mukherjee ☛ Bypass PostgreSQL catalog overhead with direct partition hash calculations
Hash partitioning works well for high-volume tables with unpredictable access patterns, scenarios requiring parallel processing across partitions, and cases where you need load balancing without hotspots. For complex systems, you might implement two-level partitioning—first by user for data isolation, then by event type to further distribute the load.
-
PostgreSQL ☛ pgCompare Community v1.0.0 Released – Free PostgreSQL Schema Comparison for Faster, Safer Deployments
pgCompare Community helps you stay in control of schema changes across development, test, and production environments.
pgCompare offers a fast, reliable way to compare PostgreSQL database schemas and deploy changes safely and efficiently.