PgCon 2020 Developer Unconference/Building Benchmarks

From PostgreSQL wiki
Jump to navigationJump to search

Note: To be saved in wiki.postgresql.org after session.

Talking points: 1. Competitive Benchmarking 2. Metrics 3. Performance 4. TPS/TPM: Transaction Rate OLTP oriented 4. Query Execution time: e.g. BI oriented - how fast does a reporting query run 4. Load time: BI oriented 4. Refresh time: BI oriented 3. Cost - is this practical with open source? 4. Professional services 4. Hardware - maybe just detailed hardware configuration 3. Other metrics 2. How to enforce fairness? 3. Licensing 4. GPL: recommended 4. Artistic License: not OSI approved 3. Neutral site for publications 3. Other aspects/topics 1. Open Source Benchmarking Kit 2. Considerations 3. Create or adapt a project that people can agree to work together on 4. Licensing 4. Language 4. Postgres specific or inclusive to other open source projects? 3. Start with a simple workload 4. Easy to run 4. Easy to develop 2. Designs 3. BI 4. Schema Design & Data Generation 4. Queries 3. OLTP 4. Schema Design & Data Generation 4. Transaction Definitions 4. Workload Profile 4. Transaction manager: build vs use existing 4. Driver: how to build 3. Others? 1. Stay in touch? 2. Mailing list