Update vs Insert in SQL
May 25th, 2009 by sherlock Hit :: 390
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”.
May 25th, 2009 by sherlock Hit :: 390
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”.