1
A new storage engine for PostgreSQL to provide better control over bloat
In the past few years, PostgreSQL has advanced a lot in terms of features, performance, and scalability for many-core systems. However, o...
Amit Kapila
You can control the degree of parallelism using the max_parallel_apply_workers_per_subscription parameter. By default, this is set to 2 , allowing two large transactions to be applied in parallel per subscription.
- Popular posts
- 4
- Total points
- 711
- HN comments
- 154
- Rank
- #3,370 personal
Visit amitkapila16.blogspot.com → RSS feedOn Hacker News Mar 2017 – May 2020
2
Hash indexes are faster than btree indexes?
PostgreSQL have supported Hash Index for a long time, but they are not much used in production mainly because they are not durable. Now, ...
3
Improved vacuum in PostgreSQL 13
Vacuum is one of the sub-systems in PostgreSQL which gets improved with each release. I have checked past five releases and each has qu...
4
Parallel Index Scans in PostgreSQL
There is a lot to say about parallelism in PostgreSQL. We have come a long way since I wrote my first post on this topic ( Parallel Sequen...