[Info-ingres] Number and Size of Transactions
Karl and Betty Schendel
schendel at kbcomputer.com
Tue Jan 28 11:20:57 UTC 2020
> On Jan 28, 2020, at 1:58 AM, Steve <s.anderson.au at gmail.com> wrote:
>
>
> However, I do have one question. Am I correct in thinking that the amount written and read from the transaction log has no correlation to the amount written and read to the data files holding the table data?
>
Amount read, no correlation. Amount written, there is a loose connection,
in that data written has to be logged first; but since table updates rewrite
entire pages, there's likely to be more table data written when updating
or deleting. When inserting, hard to say.
Karl
More information about the Info-ingres
mailing list