Re: PostgreSQL Read-only mode usage - Mailing list pgsql-general

From Francisco Olarte
Subject Re: PostgreSQL Read-only mode usage
Date
Msg-id CA+bJJbyV1LPs6ZSS04mFcHDBXTRYUBFDLxewsWhXymDZcgtKHQ@mail.gmail.com
Whole thread Raw
In response to PostgreSQL Read-only mode usage  (Jason Long <hack3rcon@yahoo.com>)
Responses Re: PostgreSQL Read-only mode usage  (Jason Long <hack3rcon@yahoo.com>)
List 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 by date:

Previous
From: Dimitrios Apostolou
Date:
Subject: Re: Orphan files filling root partition after crash
Next
From: Andreas Kretschmer
Date:
Subject: Re: PostgreSQL Read-only mode usage