On 10/14/06, Chris Mair <[EMAIL PROTECTED]> wrote:
The interesting part is the graph that shows updates / sec real time vs. running total of updates: http://www.1006.org/misc/20061014_pgupdates_bench/results.png
one small thing: the variances inside the trendline are caused by using integer timestamps...each slanted line is one second. The blue line has a very slight wobble which is the effects of the vacuum..its very slight. Actually in this test it would probably be good to vacuum extremely often, like every 100 records or so. merlin ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match