If the dump was taken with pd_dump -Fd and pg_restore -j has no effect on
restore time, that’s a good clue.
You can start with testing deferring checkpoints, by setting wal_max_size = 1TB
and checkpoint_timeout = 10h, and see how this affects the pg_restore (should
be limited by WAL write throug
Hello,
I would greatly appreciate your insight into an issue where pg_restore
runs significantly slower than expected, even though the underlying
storage shows very high random write throughput. I am trying to
understand which PostgreSQL mechanisms or system layers I should
investigate next in ord
On Wed, 2025-12-03 at 14:45 -0500, Tim Fors wrote:
> Do you have any further thoughts re: addressing this requirement
> (client-side cursor support)? Is this a requirement that the PGSQL
> community would consider implementing in libpq? Without it, it seems
> like a huge impediment to adoption of P
