Abstract
The TPC has been developing a publicly available, end-to-end benchmarking kit to run the new TPC-V benchmark, with the goal of measuring the performance of databases subjected to the variability and elasticity of load demands that are common in cloud environments. This kit is being developed completely from scratch in Java and C++ with PostgreSQL as the target database. Since the TPC-V workload is based on the mature TPC-E benchmark, the kit initially implements the TPC-E schema and transactions. In this paper, we will report on the status of the kit, describe the architectural details, and provide results from prototyping experiments at performance levels that are representative of enterprise-class databases. We are not aware of other PostgreSQL benchmarking results running at the levels we will describe in the paper. We will list the optimizations that were made to PostgreSQL parameters, to hardware/operating system/file system settings, and to the benchmarking code to maximize the performance of PostgreSQL, and saturate a large, 4-socket server.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Bond, A., Kopczynski, G., Reza Taheri, H.: Two Firsts for the TPC: A Benchmark to Characterize Databases Virtualized in the Cloud, and a Publicly-Available, Complete End-to-End Reference Kit. In: Nambiar, R., Poess, M. (eds.) TPCTC 2012. LNCS, vol. 7755, pp. 34–50. Springer, Heidelberg (2013)
Figueiredo, R., Dinda, P.A., Fortes, J.A.B.: ‘Guest Editors’ Introduction: Resource Virtualization Renaissance. Computer 38(5), 28–31 (2005), http://www2.computer.org/portal/web/csdl/doi/10.1109/MC.2005.159
Nanda, S., Chiueh, T.-C.: A Survey on Virtualization Technologies. Technical Report ECSL-TR-179, SUNY at Stony Brook (February 2005), http://www.ecsl.cs.sunysb.edu/tr/TR179.pdf
Rosenblum, M., Garfinkel, T.: Virtual Machine Monitors: Current Technology and Future Trends. Computer 38(5), 39–47 (2005)
Sethuraman, P., Reza Taheri, H.: TPC-V: A Benchmark for Evaluating the Performance of Database Applications in Virtual Environments. In: Nambiar, R., Poess, M. (eds.) TPCTC 2010. LNCS, vol. 6417, pp. 121–135. Springer, Heidelberg (2011)
Smith, G.: PostgreSQL 9.0 High Performance. Packt Publishing (October 20, 2010)
Smith, W.D., Sebastian, S.: Virtualization Performance Insights from TPC-VMS, http://www.tpc.org/tpcvms/tpc-vms-2013-1.0.pdf
SPECvirt_sc2010 benchmark info, SPEC Virtualization Committee, http://www.spec.org/virt_sc2010/
SPECvirt_sc2013 benchmark info, SPEC Virtualization Committee, http://www.spec.org/virt_sc2013/
TPC: Detailed TPC-C description, http://www.tpc.org/tpcc/detail.asp
TPC: Detailed TPC-E Description, http://www.tpc.org/tpce/spec/TPCEDetailed.doc
TPC: TPC Benchmark H Specification, http://www.tpc.org/tpch/spec/tpch2.14.4.pdf
TPC: TPC Benchmark DS Specification, http://www.tpc.org/tpcds/spec/tpcds_1.1.0.pdf
VMware, Inc., http://www.vmware.com/products/vmmark/overview.html
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Bond, A., Johnson, D., Kopczynski, G., Taheri, H.R. (2014). Architecture and Performance Characteristics of a PostgreSQL Implementation of the TPC-E and TPC-V Workloads. In: Nambiar, R., Poess, M. (eds) Performance Characterization and Benchmarking. TPCTC 2013. Lecture Notes in Computer Science, vol 8391. Springer, Cham. https://doi.org/10.1007/978-3-319-04936-6_6
Download citation
DOI: https://doi.org/10.1007/978-3-319-04936-6_6
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-04935-9
Online ISBN: 978-3-319-04936-6
eBook Packages: Computer ScienceComputer Science (R0)