Re: [PATCHES] pgbench: Support Multiple Simultaneous Runs (with Mean and Std. Dev.)
Tom, I noticed in this thread: http://archives.postgresql.org/pgsql-performance/2005-12/msg00206.php you state: Try something like -s 10 -c 10 -t 3000 to get numbers reflecting test conditions more like what the TPC council had in mind when they designed this benchmark. I tend to repeat such a test 3 times to see if the numbers are repeatable, and quote the middle TPS number as long as they're not too far apart. The -x I added is to make your 3 times easier. Sure, it's just sugar, but if this is part of the recommended use of the tool, or even a personal case study from the core team, I figured it might be of use to others. Anyway, just a followup since I was going through the archives and found a mild argument in favor it from you. :) -- Thomas F. O'Connell Database Architecture and Programming Co-Founder Sitening, LLC http://www.sitening.com/ 3004 B Poston Avenue Nashville, TN 37203-1314 615-260-0005 (cell) 615-469-5150 (office) 615-469-5151 (fax) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [PATCHES] pgbench: Support Multiple Simultaneous Runs (with Mean and Std. Dev.)
I guess I was thinking that the multiple iterations allow for easier pinpointing of noise on the system. I think I remember originally writing this during an episode where successive runs of pgbench were yielding wildly different results, and I wound up wanting an easy way to detect this and examine it further, so standard deviations in smaller sets of runs seemed an easy way to do it. With large numbers of transactions, any noise in the system would get smoothed out. I guess I like the ability to see the incremental behavior of the system when using pgbench, and this lets me run it for a long enough duration inspecting more often. If this isn't deemed generally useful functionality, that's fine. -- Thomas F. O'Connell Database Architecture and Programming Co-Founder Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 (cell) 615-469-5150 (office) 615-469-5151 (fax) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] pg_autovacuum UPDATE_INTERVAL cmd arg
Well, then it'll probably be moot for 8.1 if all goes well and autovac gets integrated. -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Apr 18, 2005, at 10:36 PM, Bruce Momjian wrote: Also, since this is an additional feature, I assume it isn't for 8.0.X. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])