Re: Catching up with performance & PostgreSQL 15

2022-11-28 Thread Josh Berkus
lz4 # v14 recovery_init_sync_method = syncfs # v14 check_client_connection_interval = ... # v14 wal_compression = {lz4,zstd} # v15 If anyone has links to blogs or other things that discuss the performance implications of the above settings that would be wonderful! -- Josh Berkus

Catching up with performance & PostgreSQL 15

2022-11-28 Thread Josh Berkus
must-tunes? I've heard about new parallel stuff an JIT, but neither is that applicable to my use-case. -- Josh Berkus

Missed query planner optimization: `n in (select q)` -> `n in (q)`

2022-06-12 Thread Josh
Hey y'all! So recently, I ran into an issue where a query I wrote wasn't using an index, presumably because what I was doing was too hard for the query planner to figure out. I've distilled the problem into its essence to the best of my ability, and found that it's because `select` seems to hin