út 30. 6. 2026 v 22:21 odesílatel Dean Rasheed <[email protected]> napsal:
> On Tue, 30 Jun 2026 at 20:29, Pavel Stehule <[email protected]> > wrote: > > > > I am testing this patchset. Generally, it looks very well. I didn't see > any bloat on catalog > > > > I found an issue - TRUNCATE waits when gtt is used by different > transactions, and TRUNCATE removes content in all sessions. > > > > Is it expected? > > Thanks for testing! > > The waiting issue for TRUNCATE is interesting. I hadn't considered > that at all, so TRUNCATE on a global temporary table still takes an > access exclusive lock, like any other table, but I guess that's not > necessary. I wonder what lock level we could reduce it to. > > I can't reproduce TRUNCATE removing content in all sessions, but > that's definitely not supposed to happen. Can you share what you did > to cause that? > > I cannot reproduce it now. I was confused. I am sorry for the noise. Regards Pavel > Regards, > Dean >
