[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