Re: Forbid to DROP temp tables of other sessions - Mailing list pgsql-hackers

From Maxim Orlov
Subject Re: Forbid to DROP temp tables of other sessions
Date
Msg-id CACG=ezZx60QHeLP0xkkoe4wugg8MVkC_qGzZ50tEU2YzORyqJA@mail.gmail.com
Whole thread Raw
In response to Re: Forbid to DROP temp tables of other sessions  ("Andrey M. Borodin" <x4mmm@yandex-team.ru>)
List pgsql-hackers


On Sat, 23 Nov 2024 at 21:13, Andrey M. Borodin <x4mmm@yandex-team.ru> wrote:
What if we say it's not a bug, but a feature. Will it break some contracts with user or some functionality?

An important thing to note here. We have to trade off an opportunity to significantly improve temp tables performance by removing locks for a "not a bug, but a feature". This seems odd to me. Arguably, the number of people who need faster temp relations is greater than the number of people who want to have access to temp relations of other backends.

--
Best regards,
Maxim Orlov.

pgsql-hackers by date:

Previous
From: Andrei Lepikhov
Date:
Subject: Re: POC, WIP: OR-clause support for indexes
Next
From: Amit Kapila
Date:
Subject: Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description