Vota in Free Arena

Notizie··1 min di lettura·Dati aggiornati automaticamente

PostgreSQL 19 rilasciato con supporto standby read‑your‑writes e comando REPACK

La nuova versione aggiunge WAIT FOR LSN per la coerenza, REPACK (CONCURRENTLY) per la manutenzione delle tabelle e diverse migliorie per sviluppatori e replica.

The PostgreSQL Global Development Group announced PostgreSQL 19 on 19 November 2026, two months later than the usual September schedule due to a surge of issues tied to AI‑reported vulnerabilities.

Key new features include the WAIT FOR LSN command, which lets applications on standby servers wait for a specific WAL position before reading, ensuring read‑your‑writes consistency.

The release also introduces the REPACK (CONCURRENTLY) command, allowing tables to be reclaimed and reordered without blocking reads or writes, replacing VACUUM FULL and CLUSTER for most use cases.

Developers gain INSERT … ON CONFLICT DO SELECT for "get or create" patterns, the pg_plan_advice extension for stabilising query plans, and logical replication improvements such as automatic WAL level elevation and sequence replication.

Autovacuum now supports parallel index vacuuming, new monitoring views (pg_stat_lock, pg_stat_recovery, pg_stat_autovacuum_scores) were added, and COPY can output JSON data.

Cosa significa per te

These enhancements make PostgreSQL more reliable for AI‑driven workloads that require low‑latency reads from replicas. Free‑software users benefit from the ability to maintain large tables without downtime, while developers can simplify common patterns and improve query performance without proprietary tools.

Fonti

Scritto automaticamente dalle fonti sopra, poi controllato dal nostro codice: ogni numero e nome deve comparire, e nessuna frase può copiare una fonte. Hai trovato un errore? Segnalalo.

Classifica dei modelli gratis

Quale AI puoi usare gratis oggi?

Tutti i modelli AI gratuiti, classificati da voti umani anonimi, con la memoria e la velocità necessarie sulla tua GPU.

Apri la classifica →

Condividi questa pagina:XLinkedInRedditWhatsApp

Premi / o Ctrl+K per cercare da qualsiasi pagina.