Re: Subplan result caching

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Subplan result caching
Date: 2018-05-23 10:03:30
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Heikki Linnakangas wrote:
> I've been working on a patch to add a little cache to SubPlans, to speed
> up queries with correlated subqueries, where the same subquery is
> currently executed multiple times with the same parameters. The idea is
> to cache the result of the subplan, with the correlation vars as the
> cache key.

I like the idea.

I think the cache should be limited in size, perhaps by work_mem.
Also, there probably should be a GUC for this, defaulting to "off".

Laurenz Albe

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Vladimir Sitnikov 2018-05-23 10:10:49 Re: Subplan result caching
Previous Message Heikki Linnakangas 2018-05-23 09:31:40 Subplan result caching