"Simon Riggs" <[EMAIL PROTECTED]> writes: > On Tue, 2007-08-07 at 13:16 +0100, Heikki Linnakangas wrote: >> I ran some CPU intensive pgbench tests on HOT. Results are not >> surprising, HOT makes practically no difference on the total transaction >> rate, but reduces the need to vacuum: >> ... > Nor would I expect anything else, on this test.
I think the surprising thing was that it wasn't slower due to the extra cpu spent pruning tuples. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings