Re^2: Writing to a file atomically without renaming

Yes, it must be stored in the filesystem. I'm starting to wonder how exactly RDBMS implement transactions. I don't think they use the rename() trick...

Comment on Re^2: Writing to a file atomically without renaming

Replies are listed 'Best First'.
Re^3: Writing to a file atomically without renaming by waswas-fng (Curate) on Jun 30, 2005 at 20:02 UTC
They write blocks of data to holes in the file or at the end of the file, and if the transaction is committed they then change pointers in the tablespace to the new data, else if rollback they leave the pointers at the old data locations. -Waswas	[reply]