Re: [HACKERS] [PATCH] A hook for session start - Mailing list pgsql-hackers

From Jim Mlodgenski
Subject Re: [HACKERS] [PATCH] A hook for session start
Date
Msg-id CAB_5SRcX3-3uPobf=8MMTS8bNQzD=KT_gBVw6rO4rFy5vpBkNA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] [PATCH] A hook for session start  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] [PATCH] A hook for session start
List pgsql-hackers


> Can a user do anything remotely interesting or useful without hitting either
> ExecutorStart_hook or ProcessUtility_hook? They can parse queries I guess
> but you could just set your hook up in the parser instead. If you hook the
> parser all they can do is open an idle session and sit there...

That's an exceedingly-weak argument for rejecting this patch.  The
fact that you can probably hack around the lack of a hook for most
reasonable use cases is not an argument for having a hook that does
what people actually want to do.


When I first saw this thread, my initial thought of a use case is to prepare some key application queries so they are there and ready to go. That would need to be before the ExecutorStart_hook or ProcessUtility_hook if an app would just want to execute the prepared statement.

 

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [HACKERS] autovacuum can't keep up, bloat just continues to rise
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] [COMMITTERS] pgsql: Add a Gather executor node.