Re: PostgreSQL Read-only mode usage

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: Jason Long <hack3rcon(at)yahoo(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL Read-only mode usage
Date: 2024-02-28 12:53:31
Message-ID: CA+bJJbyV1LPs6ZSS04mFcHDBXTRYUBFDLxewsWhXymDZcgtKHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 28 Feb 2024 at 13:34, Jason Long <hack3rcon(at)yahoo(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2024-02-28 12:55:34 Re: PostgreSQL Read-only mode usage
Previous Message Dimitrios Apostolou 2024-02-28 12:51:31 Re: Orphan files filling root partition after crash