Hacker News new | ask | show | jobs
by endorphone 3179 days ago
>The server is still single-threaded though -- they are getting the parallelism by starting multiple processes to do independent chunks of work.

So...it isn't single threaded then? I mean that is exactly how the most advanced competitors operate (Oracle, SQL Server) as well -- a given connection stays on one thread, with the advantages that confers, unless the planner decides to parallelize.
1 comments
adzm 3179 days ago
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.
link
tychver 3179 days ago
I think bitmap heap scans have had concurrent IO for quite a while now? There's the effective_io_concurrency setting for it.
link