Re: New Feature Request

2020-05-26 Thread Bert Scalzo
- which I cannot argue with. On Tue, May 26, 2020 at 2:17 AM Konstantin Knizhnik < k.knizh...@postgrespro.ru> wrote: > > > On 26.05.2020 04:47, Tomas Vondra wrote: > > On Mon, May 25, 2020 at 09:21:26PM -0400, Bruce Momjian wrote: > >> On Mon, May 25, 2020 at 07:53:4

New Feature Request

2020-05-25 Thread Bert Scalzo
I am reposting this from a few months back (see below). I am not trying to be a pest, just very motivated. I really think this feature has merit, and if not generally worthwhile, I'd be willing to pay someone to code it for me as I don't have strong enough C skills to modify the PostgreSQL code

New feature request: Query Rewrite Cache

2020-03-09 Thread Bert Scalzo
MySQL has a really useful feature they call the query rewrite cache. The optimizer checks incoming queries to see if a known better rewrite has been placed within the query rewrite cache table. If one is found, the rewrite replaces the incoming query before sending it to the execution engine. This