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