Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
4
Newest
 Teacher
Impact
~55 people reached

  • 0 posts edited
  • 0 helpful flags
  • 10 votes cast
Jul
1
comment Locking issues under transaction on Postgres
@CraigRinger you're right I know better Oracle than PostgreSQL... I should learn more about it. By the way the write-ahead log may hit a limit on disk, right ? Please fell free to edit my answer to replace concepts.
Jul
1
comment Locking issues under transaction on Postgres
I really think that is the problem. None DB engine has such a limit... except the undo tablespace size (to keep old values of modified rows) and redo log size (transaction journal) written on a "finite" file system. By the way, the larger a transaction is, the slower it may be to process additional operations and to commit.
Jul
1
comment Locking issues under transaction on Postgres
I agree. But it means you may create. in worst case, a transaction updating 12K rows, right ?
Oct
3
comment MySql - ERROR 1071 Specified key was too long; max key length is 1000 bytes while restoring dump
Sorry but SET GLOBAL default_storage_engine answers ERROR 1193 (HY000): Unknown system variable 'default_storage_engine' and I tried SET GLOBAL storage_engine = 'InnoDB'; but got ERROR 1286 (42000): Unknown table engine 'InnoDB'. What is wrong ?