• Etsuro Fujita's avatar
    Add support for asynchronous execution. · 27e1f145
    Etsuro Fujita authored
    This implements asynchronous execution, which runs multiple parts of a
    non-parallel-aware Append concurrently rather than serially to improve
    performance when possible.  Currently, the only node type that can be
    run concurrently is a ForeignScan that is an immediate child of such an
    Append.  In the case where such ForeignScans access data on different
    remote servers, this would run those ForeignScans concurrently, and
    overlap the remote operations to be performed simultaneously, so it'll
    improve the performance especially when the operations involve
    time-consuming ones such as remote join and remote aggregation.
    
    We may extend this to other node types such as joins or aggregates over
    ForeignScans in the future.
    
    This also adds the support for postgres_fdw, which is enabled by the
    table-level/server-level option "async_capable".  The default is false.
    
    Robert Haas, Kyotaro Horiguchi, Thomas Munro, and myself.  This commit
    is mostly based on the patch proposed by Robert Haas, but also uses
    stuff from the patch proposed by Kyotaro Horiguchi and from the patch
    proposed by Thomas Munro.  Reviewed by Kyotaro Horiguchi, Konstantin
    Knizhnik, Andrey Lepikhov, Movead Li, Thomas Munro, Justin Pryzby, and
    others.
    
    Discussion: https://postgr.es/m/CA%2BTgmoaXQEt4tZ03FtQhnzeDEMzBck%2BLrni0UWHVVgOTnA6C1w%40mail.gmail.com
    Discussion: https://postgr.es/m/CA%2BhUKGLBRyu0rHrDCMC4%3DRn3252gogyp1SjOgG8SEKKZv%3DFwfQ%40mail.gmail.com
    Discussion: https://postgr.es/m/20200228.170650.667613673625155850.horikyota.ntt%40gmail.com
    27e1f145
postgresql.conf.sample 27.7 KB