| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de> |
| Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: On-demand running query plans using auto_explain and signals |
| Date: | 2015-09-17 12:06:53 |
| Message-ID: | CA+Tgmobu1DvQzahsSX=u9Ti=g4zJmxNmaNHC2-ru8sGBxmtvbw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Sep 15, 2015 at 5:00 AM, Shulgin, Oleksandr
<oleksandr(dot)shulgin(at)zalando(dot)de> wrote:
> Please see attached for implementation of this approach. The most
> surprising thing is that it actually works :)
It's cool to see these interesting ideas for using some of the code
I've been working on for the last couple of years. However, it seems
to me that a better design would avoid the use of shm_mq. Instead of
having the guy who asks the question create a DSM, have the guy who
sends back the answer create it. Then, he can just make the DSM big
enough to store the entire string. I think that's going to be a lot
more robust than what you have here.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2015-09-17 12:14:05 | Re: On-demand running query plans using auto_explain and signals |
| Previous Message | Alexander Korotkov | 2015-09-17 11:35:20 | LW_SHARED_MASK macro |