Re: PostgreSQL Read-only mode usage

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: PostgreSQL Read-only mode usage
Дата
Msg-id CA+bJJbyV1LPs6ZSS04mFcHDBXTRYUBFDLxewsWhXymDZcgtKHQ@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL Read-only mode usage  (Jason Long <hack3rcon@yahoo.com>)
Ответы Re: PostgreSQL Read-only mode usage
Список pgsql-general
On Wed, 28 Feb 2024 at 13:34, Jason Long <hack3rcon@yahoo.com> wrote:
> What is the use of a database in read-only mode?

Normally it is a connection/session to the database what is in
read-only mode, not the whole database.

As it has been pointed out, you connect in read only mode to read, so
you are protected from accidental modifications. Also, knowing your
transactions are not going to write make life easier for optimizers
and other things.

Francisco Olarte.



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

Предыдущее
От: Dimitrios Apostolou
Дата:
Сообщение: Re: Orphan files filling root partition after crash
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: PostgreSQL Read-only mode usage