From: | Rama Krishnan <raghuldrag(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgresql acid components |
Date: | 2022-09-14 07:17:20 |
Message-ID: | CAJWX+EPQWHtEVGDsDtvvHJdLhRwLdvpF=C4wnHKmeikcfnE3nQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Adrian
Thanks for your valuable reply.
On Wed, 14 Sep, 2022, 01:11 Adrian Klaver, <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 9/12/22 09:34, Rama Krishnan wrote:
> > Hi all,
> >
> > In ACID property which postgresql components is supporting it
> >
> >
>
> The database as whole is ACID compliant per:
>
> https://www.postgresql.org/about/
>
> "...has been ACID-compliant since 2001...".
>
> From what I remember there are some commands that do not run in a
> transaction block:
>
> https://www.postgresql.org/docs/current/sql-createdatabase.html
>
> https://www.postgresql.org/docs/current/sql-vacuum.html
>
> Some forms of below do not run in transaction block:
>
> https://www.postgresql.org/docs/14/sql-reindex.html
>
> https://www.postgresql.org/docs/14/sql-altersubscription.html
>
> https://www.postgresql.org/docs/14/sql-alterdatabase.html
>
> Your best bet is to look at the commands listed here:
>
> https://www.postgresql.org/docs/14/sql-commands.html
>
> to check before using for first time.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2022-09-14 07:21:35 | Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? |
Previous Message | Bryn Llewellyn | 2022-09-13 22:35:20 | Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? |