Skip to content

Instantly share code, notes, and snippets.

@poing
Last active July 23, 2018 16:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save poing/45fb5db1b65a270b2357799738ef1d15 to your computer and use it in GitHub Desktop.
Save poing/45fb5db1b65a270b2357799738ef1d15 to your computer and use it in GitHub Desktop.

Test parameters:

--iterations=2 --concurrency=6 --iterations=1000


Using view without indexes: It took over 30 minutes to run the benchmark test.

Benchmark
	Average number of seconds to run all queries: 1.748 seconds
	Minimum number of seconds to run all queries: 1.417 seconds
	Maximum number of seconds to run all queries: 2.009 seconds
	Number of clients running queries: 6
	Average number of queries per client: 10


User time 0.63, System time 5.02
Maximum resident set size 6236, Integral resident set size 0
Non-physical pagefaults 10743, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 156957, Involuntary context switches 1860
00:55:03.455759338 - 01:24:11.694444807
00:31:08.238685469

Using a dedicated table with indexes: This benchmark test took seconds to complete.

Benchmark
	Average number of seconds to run all queries: 0.010 seconds
	Minimum number of seconds to run all queries: 0.006 seconds
	Maximum number of seconds to run all queries: 0.096 seconds
	Number of clients running queries: 6
	Average number of queries per client: 10


User time 0.75, System time 2.21
Maximum resident set size 4196, Integral resident set size 0
Non-physical pagefaults 10563, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 97014, Involuntary context switches 1578
00:51:53.653785574 - 00:52:04.829810291
Test Duration: 00:00:11.176024717
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment