Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Tag: benchmark
Why does MariaDB 10.1.2 blow away MySQL 5.6.22 in sysbench?
Question : Problem Maria DB is doing roughly twice the number of transactions that mysql is using standard oltp benchmark. […]
SQL Server 2012 Performance Test
Question : I’ve been given a task to test where an SQL Server 2012 can achieve better performances – we […]
How can I measure the number of IOPs for a certain query
Question : I need to estimate the max IOPs for a certain MySQL DB (one that does not exist yet). […]
Why is array_agg() slower than the non-aggregate ARRAY() constructor?
Question : I was just reviewing some old code written for pre-8.4 PostgreSQL, and I saw something really nifty. I […]
Does Greg Rahn’s “join order benchmark” reflect real world OLAP join scenarios?
Question : Greg Rahn’s “join order benchmark” has dozens of inner join queries on the IMDB database. Does this benchmark […]
Postgres REINDEX time estimate
Question : I’ve got an older DB (postgres 10.15) that’s not yet been upgraded. One problematic table had a few […]
How to use the ‘select benchmark’ command on a procedure
Question : I am trying to check which of my procedures is slowest and thus needs optimization. I currently have […]
Why is FROM VALUES massively faster than visiting a table once?
Question : Given this setup, CREATE TABLE t(foo) AS SELECT ‘foobar’::text; Why is this query, EXPLAIN (ANALYZE, TIMING OFF) SELECT […]
Measuring IOPS in SQL 2014
Question : We have a LANDEsk migration going on where several servers are being consolidated into one SQL 2014 Cluster. […]