Anayrat links

Storage Performance Benchmarking with FIO - THE SAN GUY

fio · benchmark

September 27, 2018 at 3:46:40 PM GMT+2 * · permalink

https://thesanguy.com/2018/01/24/storage-performance-benchmarking-with-fio/

AMD - NVMe Performance Testing and Optimization Application Note

NVMe · benchmark · fio

September 27, 2018 at 3:44:00 PM GMT+2 * · permalink

http://developer.amd.com/wordpress/media/2013/12/56163-PUB_0.72.pdf

What is the “(scanning)” variant of a loose index scan? | MySQL Server Blog

MySQL · loose_index_scan

September 27, 2018 at 2:22:49 PM GMT+2 * · permalink

https://mysqlserverteam.com/what-is-the-scanning-variant-of-a-loose-index-scan/

The design and implementation of modern column-oriented database systems | the morning paper

database · Publication · column_storage

September 27, 2018 at 1:30:13 PM GMT+2 * · permalink

https://blog.acolyer.org/2018/09/26/the-design-and-implementation-of-modern-column-oriented-database-systems/

Fetch First Rows Just Got Faster | Oracle Optimizer Blog

SQL · Oracle · limit

September 27, 2018 at 1:29:00 PM GMT+2 * · permalink

https://blogs.oracle.com/optimizer/fetch-first-rows-just-got-faster

How to Use SQL UPDATE .. RETURNING to Run DML More Efficiently – Java, SQL and jOOQ.

PostgreSQL · SQL

September 26, 2018 at 6:01:41 PM GMT+2 * · permalink

https://blog.jooq.org/2018/09/26/how-to-use-sql-update-returning-to-run-dml-more-efficiently/

Part I – Playing around with Linux perf events and Flame Graphs on PostgreSQL – The little things about databases….

PostgreSQL · perf · flamegraph

September 26, 2018 at 3:44:41 PM GMT+2 * · permalink

https://newbiedba.wordpress.com/2018/09/26/part-i-playing-around-with-linux-perf-events-and-flame-graphs-on-postgresql/

Hacking the Query Planner - Tom Lane

PostgreSQL · planner

September 26, 2018 at 3:29:20 PM GMT+2 * · permalink

https://www.pgcon.org/2011/schedule/attachments/188_Planner%20talk.pdf

USE, RED and real world PgBouncer monitoring – okmeter.io blog

PgBouncer

September 26, 2018 at 9:47:55 AM GMT+2 * · permalink

https://blog.okmeter.io/use-red-and-real-world-pgbouncer-monitoring-61b34ebeebb8

A history lesson on SQL joins (in Postgres)

PostgreSQL · Join · pagination · offset

September 26, 2018 at 9:46:18 AM GMT+2 * · permalink

https://www.citusdata.com/blog/2018/09/25/history-on-joins-in-postgres/

Running a database on EC2? Your clock could be slowing you down.

linux · hardware · Virtualisation

September 23, 2018 at 5:49:05 PM GMT+2 * · permalink

https://heapanalytics.com/blog/engineering/clocksource-aws-ec2-vdso

Online Re-indexing in PostgreSQL – Technology Blog

PostgreSQL · reindex

September 21, 2018 at 8:49:38 PM GMT+2 * · permalink

https://techblog.cantabcapital.com/2017/06/30/online-re-indexing-in-postgresql/

On Rocks and Sand | Optimizing Postgres Column Order

PostgreSQL · Internal

September 21, 2018 at 8:20:28 PM GMT+2 * · permalink

https://blog.2ndquadrant.com/on-rocks-and-sand/

How to Write a Multiplication Aggregate Function in SQL – Java, SQL and jOOQ.

PostgreSQL · Aggregate · SQL

September 21, 2018 at 12:30:17 PM GMT+2 * · permalink

https://blog.jooq.org/2018/09/21/how-to-write-a-multiplication-aggregate-function-in-sql/

How to Reduce Syntactic Overhead Using the SQL WINDOW Clause – Java, SQL and jOOQ.

PostgreSQL · Window_function · SQL

September 20, 2018 at 5:43:08 PM GMT+2 * · permalink

https://blog.jooq.org/2018/09/20/how-to-reduce-syntactic-overhead-using-the-sql-window-clause/

Partitioning Improvements in PostgreSQL 11

PostgreSQL · partionning · partition_pruning

September 20, 2018 at 1:54:05 PM GMT+2 * · permalink

https://blog.2ndquadrant.com/partitioning-improvements-pg11/

Hypothetical Partitioning for PostgreSQL

PostgreSQL · partionning · hypopg

September 20, 2018 at 1:45:48 PM GMT+2 * · permalink

https://www.slideshare.net/YuzukoHosoya/hypothetical-partitioning-for-postgresql

Cost of a Join - Part 2: Enums, Wider Tables

PostgreSQL · Join · enum

September 19, 2018 at 9:17:12 PM GMT+2 * · permalink

https://www.brianlikespostgres.com/cost-of-a-join-part-2.html

Correlation of PostgreSQL columns explained - Cybertec

PostgreSQL · index · Correlation

September 19, 2018 at 12:33:35 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/column-correlation-explained/

Why Covering Indexes Are Incredibly Helpful

PostgreSQL · Performance · index · covering

September 17, 2018 at 2:19:53 PM GMT+2 * · permalink

https://info.crunchydata.com/blog/why-covering-indexes-are-incredibly-helpful