News for hackers. Stuff that matters.
Re:PostgreSQL 10 Released by adzm on Thursday October 05, 2017 @02:59PM (#15411707)
To be technical, MSSQL uses its own bespoke scheduling, and will preempt the thread for io. All io is nonblocking. The physical thread can vary for this reason. PGSQL really does use synchronous io and a single thread though. The former is probably more scalable but the latter has been serving PGSQL fine, too.
Re:PostgreSQL 10 Released by tychver on Friday October 06, 2017 @04:21AM (#15415208)
I think bitmap heap scans have had concurrent IO for quite a while now? There's the effective_io_concurrency setting for it.