Re: Locks on unlogged tables are locked?!

2023-11-21 Thread Bruce Momjian
On Tue, Nov 21, 2023 at 01:16:19PM -0500, Tom Lane wrote: > Bruce Momjian writes: > > Uh, was this ever addressed? I don't see the patch applied or the code > > in this area modified. > > This patch as-is would surely be disastrous: having LockAcquire > try to open the relcache entry for the

Re: Locks on unlogged tables are locked?!

2023-11-21 Thread Tom Lane
Bruce Momjian writes: > Uh, was this ever addressed? I don't see the patch applied or the code > in this area modified. This patch as-is would surely be disastrous: having LockAcquire try to open the relcache entry for the thing we're trying to lock is going to be circular in at least some

Re: Locks on unlogged tables are locked?!

2023-11-21 Thread Robert Haas
On Tue, Nov 21, 2023 at 11:49 AM Bruce Momjian wrote: > Uh, was this ever addressed? I don't see the patch applied or the code > in this area modified. I never saw this email originally, but I don't think I believe Laurenz's argument. Are all AEL-requiring operations on unlogged tables safe to

Re: Locks on unlogged tables are locked?!

2023-11-21 Thread Bruce Momjian
Uh, was this ever addressed? I don't see the patch applied or the code in this area modified. --- On Thu, May 24, 2018 at 04:33:11PM +0200, Laurenz Albe wrote: > While looking at this: >

Locks on unlogged tables are locked?!

2018-05-24 Thread Laurenz Albe
While looking at this: https://stackoverflow.com/q/50413623/6464308 I realized that "LOCK TABLE " puts a Standby/LOCK into the WAL stream, which causes a log flush at COMMIT time. That hurts performance, and I doubt that it is necessary. At any rate, DROP TABLE on an unlogged table logs nothing.