Locks on unlogged tables are locked?!

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Locks on unlogged tables are locked?!
Дата
Msg-id 1527172391.2837.41.camel@cybertec.at
обсуждение исходный текст
Ответы Re: Locks on unlogged tables are locked?!  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
While looking at this:
https://stackoverflow.com/q/50413623/6464308
I realized that "LOCK TABLE <unlogged 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.

The attached patch would take care of it, but I'm not sure
if that's the right place to check.

Yours,
Laurenz Albe
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Function Overloading
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PG11 jit failing on ppc64el