Twitxy Saved

Crunchy Data

Verified account This account is verified. Learn more

@crunchydata

Fully managed, hosted Postgres on AWS, GCP, and Azure.
crunchydata.com Joined August 2013
2.1K Following 7.6K Followers 3.7K Posts

Latest posts 5

Crunchy Data Verified account @crunchydata
Looking back since beta3 (August 13), what is in Postgres 19rc2 and what is not?

✅ still there in rc2
❌ in beta3, gone in rc2
🆕 new in rc2

Performance
✅ Async I/O workers that scale between `io_min_workers` and `io_max_workers`
✅ Parallel autovacuum
✅ `REPACK`, including `CONCURRENTLY`
✅ `pg_plan_advice` and `pg_stash_advice`

Developer Experience
❌ SQL/PGQ property graph queries
❌ `UPDATE ... FOR PORTION OF`
❌ `ALTER TABLE ... MERGE PARTITIONS` and `SPLIT PARTITION`
❌ SQL functions that return the DDL for roles, databases and tablespaces
✅ `INSERT ... ON CONFLICT DO SELECT`
✅ String functions in `jsonpath`
✅ `random()` for dates and timestamps
✅ Read-your-writes on replicas by waiting for an LSN

Security
✅ `password_expiration_warning_threshold`
✅ `md5_password_warnings`

Monitoring
✅ `pg_stat_lock` and `pg_stat_recovery`
✅ `started_by` and `mode` in `pg_stat_progress_vacuum`
✅ `EXPLAIN (ANALYZE, IO)`
❌ `pg_stat_progress_data_checksums`

Logical Replication
✅ `CREATE PUBLICATION ... EXCEPT`
✅ `CREATE SUBSCRIPTION ... SERVER`
✅ `effective_wal_level`

Defaults and Other Changes
❌ Online enabling and disabling of data checksums
✅ JIT is off by default
✅ `default_toast_compression` defaults to `lz4`
3 replies 2 reposts 13 likes 863 views View on X
Crunchy Data Verified account @crunchydata
On its last day of community support, Postgres 14.25 was released with a healthy set of security and bug fixes.

postgresql.org/docs/release/1…
Crunchy Data Verified account @crunchydata 5d
Today is Postgres 14's EOL.

When launched just over 5 years ago, it added / improved:

• SEARCH and CYCLE clauses for recursive CTEs
• Multirange types, so a set of ranges fits in one value
• date_bin(), which buckets timestamps into fixed intervals
• Subscripting for jsonb: data['user']['id']
• Pipeline mode in libpq, which sends several queries before waiting on results
• pg_stat_wal, pg_stat_progress_copy and pg_stat_replication_slots views
• pg_stat_statements tracking top-level and nested statements separately
• VACUUM that gets more aggressive as a database nears transaction ID wraparound
• B-tree index updates that reduce bloat
View quoted post on X
Crunchy Data Verified account @crunchydata
Today is Postgres 14's EOL.

When launched just over 5 years ago, it added / improved:

• SEARCH and CYCLE clauses for recursive CTEs
• Multirange types, so a set of ranges fits in one value
• date_bin(), which buckets timestamps into fixed intervals
• Subscripting for jsonb: data['user']['id']
• Pipeline mode in libpq, which sends several queries before waiting on results
• pg_stat_wal, pg_stat_progress_copy and pg_stat_replication_slots views
• pg_stat_statements tracking top-level and nested statements separately
• VACUUM that gets more aggressive as a database nears transaction ID wraparound
• B-tree index updates that reduce bloat
6 replies 4 reposts 30 likes 1.9K views View on X
Crunchy Data Verified account @crunchydata
Want to tail the output of a query? End it with `\watch`:

```
SELECT state, count(*) FROM pg_stat_activity GROUP BY state \watch
```

psql reruns it every 2 seconds, with a timestamp over each result, until you hit Ctrl-C. Handy for watching a backfill, a migration, or locks clearing.

• Pick the interval with `\watch 1`
• `\watch count=5` stops on its own
0 replies 2 reposts 18 likes 763 views View on X