hard20 pts · first answer countstransactionsdurabilityperformance
Inserting 10,000 rows one commit each
A script inserts 10,000 rows, each in its own transaction. Every commit waits about 2 ms for the WAL flush, and nothing else is slow. About how long do the commits alone take, and how can it be cut?
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- What C in ACID meansDatabase Administrator
- What I in ACID meansDatabase Administrator
- Statements without BEGINDatabase Administrator
- What a phantom read isDatabase Administrator
- PostgreSQL default isolationDatabase Administrator