using memoize in in paralel query decreases performance

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: using memoize in in paralel query decreases performance
Date: 2023-03-06 07:33:42
Message-ID: CAFj8pRD080wW5fkf3odyV5R7+vTWi42Tj-TWPmp4r+DnzQfMdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
slow memoize application/octet-stream 6.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2023-03-06 07:34:49 Re: shoud be get_extension_schema visible?
Previous Message Julien Rouhaud 2023-03-06 07:33:31 Re: shoud be get_extension_schema visible?