út 7. 3. 2023 v 10:46 odesílatel David Rowley napsal:
> On Tue, 7 Mar 2023 at 22:09, Pavel Stehule
> wrote:
> > I can live with it. This is an analytical query and the performance is
> not too important for us. I was surprised that the performance was about
> 25% worse, and so the hit ratio was
On Tue, 7 Mar 2023 at 22:09, Pavel Stehule wrote:
> I can live with it. This is an analytical query and the performance is not
> too important for us. I was surprised that the performance was about 25%
> worse, and so the hit ratio was almost zero. I am thinking, but I am not sure
> if the esti
út 7. 3. 2023 v 9:58 odesílatel David Rowley napsal:
> /On Tue, 7 Mar 2023 at 21:09, Pavel Stehule
> wrote:
> >
> > po 6. 3. 2023 v 22:52 odesílatel David Rowley
> napsal:
> >> I wonder if the additional work_mem required for Memoize is just doing
> >> something like causing kernel page cache
/On Tue, 7 Mar 2023 at 21:09, Pavel Stehule wrote:
>
> po 6. 3. 2023 v 22:52 odesílatel David Rowley napsal:
>> I wonder if the additional work_mem required for Memoize is just doing
>> something like causing kernel page cache evictions and leading to
>> fewer buffers for ixfk_ite_itemcategoryid
po 6. 3. 2023 v 22:52 odesílatel David Rowley napsal:
> On Mon, 6 Mar 2023 at 21:55, Pavel Stehule
> wrote:
> > default https://explain.depesz.com/s/fnBe
>
> It looks like the slowness is coming from the Bitmap Index scan and
> Bitmap heap scan rather than Memoize.
>
>-> Bitmap Heap Sca
On Mon, 6 Mar 2023 at 21:55, Pavel Stehule wrote:
> default https://explain.depesz.com/s/fnBe
It looks like the slowness is coming from the Bitmap Index scan and
Bitmap heap scan rather than Memoize.
-> Bitmap Heap Scan on public.item i (cost=285.69..41952.12
rows=29021 width=16) (actua
po 6. 3. 2023 v 9:16 odesílatel David Rowley napsal:
> On Mon, 6 Mar 2023 at 20:34, Pavel Stehule
> wrote:
> > In one query I can see very big overhead of memoize node - unfortunately
> with hits = 0
> >
> > The Estimate is almost very good. See details in attachment
>
> Are you able to share th
On Mon, 6 Mar 2023 at 20:34, Pavel Stehule wrote:
> In one query I can see very big overhead of memoize node - unfortunately with
> hits = 0
>
> The Estimate is almost very good. See details in attachment
Are you able to share the version number for this?
Also, it would be good to see EXPLAIN A
Hi
In one query I can see very big overhead of memoize node - unfortunately
with hits = 0
The Estimate is almost very good. See details in attachment
Regards
Pavel
slow
Description: Binary data