Re: On-demand running query plans using auto_explain and signals - Mailing list pgsql-hackers

From Shulgin, Oleksandr
Subject Re: On-demand running query plans using auto_explain and signals
Date
Msg-id CACACo5RuC_m1-U9ajtN2Hox8VZyagWAtRyQtbAvg0=CfYu0+Eg@mail.gmail.com
Whole thread Raw
In response to Re: On-demand running query plans using auto_explain and signals  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
On Tue, Sep 29, 2015 at 12:28 AM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
On 9/18/15 5:05 AM, Shulgin, Oleksandr wrote:

So this has to be the responsibility of the reply sending backend in the
end: to create and release the DSM *at some point*.

What's wrong with just releasing it at the end of the statement? When the statement is done there's no point to reading it asynchronously anymore.

That was only one of the problems in signals-based design, and it has other more significant problems.  The current approach does exactly that: allocate the segment before running the plan, release at the end of the statement.

--
Alex

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: PATCH: index-only scans with partial indexes
Next
From: Andres Freund
Date:
Subject: Re: On-demand running query plans using auto_explain and signals