Merlin Moncure <mmoncure@xxxxxxxxx> writes: > just selects. update test is also very interesting -- the only test I > did for for updates is 'update foo set x=x+1' which was a win for > btree (20-30% faster typically). perhaps this isn't algorithm induced > though -- lack of wal logging could actually hurt time to commit > because it deserializes i/o. In 9.1+, you could remove WAL from the comparison by doing the tests on an unlogged table. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
