Nov 102022
 

Reducing replication lag with IO concurrency in Postgres 15 PostgreSQL 15 improves crash recovery and physical replication performance of some large and very busy databases by trying to minimise I/O stalls. A standby server might now have an easier time keeping up with the primary. How? The change in PostgreSQL15 is that recovery now uses the maintenance_io_concurrency setting (default is 10, but you can increase it) to decide how many concurrent I/Os to try to initiate, rather than doing random read I/Os one at a time. With big and busy databases, when I/O concurrency increases, replication lag can be reduced. In this blog post, you’ll learn how recovery prefetching minimises I/O stalls and reduces replication…

External feed Read More at the Source: https://postgr.es/p/5s1

 2022-11-10  Comments Off on Planet PostgreSQL – Thomas Munro: Reducing replication lag with IO concurrency in Postgres 15
Nov 102022
 

Enlarge / Archaeologists excavated this engraved ivory comb at an ancient site in Israel. (credit: Dafna Gazit, Israel Antiquities Authority)
Several years ago, archaeologists unearthed a small ivory comb at Tel Lachsich in Israel, once a major Canaanite city-state in the second millennium BCE.  But it wasn’t until last December that someone realized the comb had an inscription using early pictograph symbols of the first alphabet. Once deciphered, the inscription turned out to be a spell for preventing an infestation of head lice, according to a new paper published in the Jerusalem Journal of Archaeology.
“This is the first sentence ever found in the Canaanite language in Israel,” said co-author Yosef Garfinkel, an archaeologist…

External feed Read More at the Source: https://arstechnica.com/?p=1895815

 2022-11-10  Comments Off on Ars Technica – Ancient wisdom: Oldest full sentence in first alphabet is about head lice