From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Number of internal operations for a single DML/DDL |
Date: | 2021-03-18 06:09:22 |
Message-ID: | CAKFQuwZN5nztiJvWxXDipJCwZ8rDPh9+BXUJ0X0qJ0MBvSoi0A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wednesday, March 17, 2021, Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> wrote:
>
> I wanted to know how many internal operations postgres performs for a
> single DML or DDL statement.
>
Why?
>
> Apart from these what all operations does postgres do internally, I wanted
> an average estimated count as I know it would be difficult to get the
> details for each of the DML/DDL statements
>
Frankly, that number doesn’t exist; the nature of the input and the state
of the system directly impacts what any individual command does internally
and so one cannot derive a count, or even an understanding of what happens,
without knowledge of those two things. Which brings us again to “why?”.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Nikhil Shetty | 2021-03-18 06:19:30 | Re: Number of internal operations for a single DML/DDL |
Previous Message | Nikhil Shetty | 2021-03-18 05:45:44 | Number of internal operations for a single DML/DDL |