RE: RE: Speeding up PostgreSQL data loading
You are viewing a single comment's thread from:

RE: Speeding up PostgreSQL data loading

Words
59
Reading
1 min
Listen
Play
3y

We generally don't need much shared_buffers to begin with because ZFS is already doing the caching. I probably will have to include my postgresql.conf in the repository.
I remember experimenting maintenance_work_mem and I do already hit the max disk utilization pretty much on gen4 NVMe raid 0.

I will certainly take a look at your video and try your suggestions. Thank you.

@mahdiyari: We generally | Ecency