Update vs Insert in SQL
May 25th, 2009 by sherlock Hit :: 5231
PostgreSQL 7.03
| Normal | autocommit on | fsync off |
| insert | update | insert | update | insert | update |
| 5:16 | 6:46 | n/a | n/a | 0:10 | 0:18 |
“Insert” is faster than “update”.
Leave a Comment Below
May 25th, 2009 by sherlock Hit :: 5231
PostgreSQL 7.03
| Normal | autocommit on | fsync off |
| insert | update | insert | update | insert | update |
| 5:16 | 6:46 | n/a | n/a | 0:10 | 0:18 |
“Insert” is faster than “update”.