Re: Number of internal operations for a single DML/DDL

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Number of internal operations for a single DML/DDL
Дата
Msg-id CAKFQuwZN5nztiJvWxXDipJCwZ8rDPh9+BXUJ0X0qJ0MBvSoi0A@mail.gmail.com
обсуждение исходный текст
Ответ на Number of internal operations for a single DML/DDL  (Nikhil Shetty <nikhil.dba04@gmail.com>)
Ответы Re: Number of internal operations for a single DML/DDL  (Nikhil Shetty <nikhil.dba04@gmail.com>)
Список pgsql-admin

On Wednesday, March 17, 2021, Nikhil Shetty <nikhil.dba04@gmail.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.

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

Предыдущее
От: Nikhil Shetty
Дата:
Сообщение: Number of internal operations for a single DML/DDL
Следующее
От: Nikhil Shetty
Дата:
Сообщение: Re: Number of internal operations for a single DML/DDL