Re: Parallel Apply - Mailing list pgsql-hackers

From Álvaro Herrera
Subject Re: Parallel Apply
Date
Msg-id aeHIVhNiFtfGss4b@alvherre.pgsql
Whole thread
In response to RE: Parallel Apply  ("Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>)
Responses Re: Parallel Apply
List pgsql-hackers
Hello,

I have a quick question about this work -- is there an expectation of
how quicker parallel apply is, compared to our normal (serial) apply,
for average cases?  Are we talking 20% faster, 2x faster, 10x faster?

(When I say average, I mean not considering fringe cases where the
workload is such that very little paralelization can be done, and also
those where you have a contrived case with one thousand parallel
processes each making progress separately to the point where you get
ridiculously high numbers.  I mean something that can occur in realistic
workloads.)

My point is that if it's 20% faster, it's nice.  But if it's, say, 4x
faster, then it's probably groundbreaking to the point that it may
enable new use cases not currently possible.

Thoughts, pointers?

Many thanks

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"¿Qué importan los años?  Lo que realmente importa es comprobar que
a fin de cuentas la mejor edad de la vida es estar vivo"  (Mafalda)



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Fix tab completion after EXCEPT (...) in IMPORT FOREIGN SCHEMA
Next
From: Chao Li
Date:
Subject: Re: repack: fix a bug to reject deferrable primary key fallback for concurrent mode