Search: [performance] - Anayrat links

The Art of Database Experiments – PostgresConf Silicon Valley 2018 / …

PostgreSQL · benchmark · Performance · tests

October 18, 2018 at 11:12:33 AM GMT+2 * · permalink

https://www.slideshare.net/samokhvalov/the-art-of-database-experiments-postgresconf-silicon-valley-2018-san-jose

Leveraging Query Parallelism In PostgreSQL

PostgreSQL · Parallel · Performance

October 16, 2018 at 5:16:45 PM GMT+2 * · permalink

http://2019.pgconf.in/wp-content/uploads/D121-Dilip-Kumar-Leveraging-intra-query-parallelism-in-PostgreSQL.pdf

Optimizing web servers for high throughput and low latency | Dropbox Tech Blog

linux · Performance

September 28, 2018 at 7:40:04 PM GMT+2 * · permalink

https://blogs.dropbox.com/tech/2017/09/optimizing-web-servers-for-high-throughput-and-low-latency/

5x Faster Spatial Join with this One Weird Trick · Paul Ramsey

PostgreSQL · Postgis · Performance · toast

September 28, 2018 at 5:28:25 PM GMT+2 * · permalink

http://blog.cleverelephant.ca/2018/09/postgis-external-storage.html

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

Lab Notes: How We Made Joins 23 Thousand Times Faster, Part Three - CrateDB

Performance · sql

August 30, 2018 at 4:29:22 PM GMT+2 * · permalink

https://crate.io/a/lab-notes-how-we-made-joins-23-thousand-times-faster-part-three/

hyperloop - Solving performance issues for your web application

Hyperloop is an ongoing research project that aims at detecting and solving performance problems for web applications built with ORM (Object-Relational Mapping) frameworks, mainly Ruby on Rails. Currently it conains:

Publication · Performance · hyperloop

July 1, 2018 at 3:28:00 PM GMT+2 * · permalink

https://hyperloop-rails.github.io

PostgreSQL Tuning: Key Things to Drive Performance | Severalnines

PostgreSQL · Performance

June 29, 2018 at 2:15:47 PM GMT+2 * · permalink

https://severalnines.com/blog/postgresql-tuning-key-things-drive-performance

Scaling Postgres at Affinity with Citus

PostgreSQL · Performance · citus

June 22, 2018 at 2:21:28 PM GMT+2 * · permalink

https://build.affinity.co/scaling-postgres-at-affinity-with-citus-bc93bb7f4441

Tuning Input/Output (I/O) Operations for PostgreSQL | Severalnines

PostgreSQL · Performance

June 22, 2018 at 2:20:58 PM GMT+2 * · permalink

https://severalnines.com/blog/tuning-io-operations-postgresql

Issues related to PL/pgSQL usage

PostgreSQL · plpgsql · Performance

May 1, 2018 at 4:54:48 PM GMT+2 * · permalink

https://postgres.cz/files/plpgsql_issues.pdf

Testing Database Changes the Right Way - Heap | Mobile and Web Analytics

PostgreSQL · Performance · tests

April 23, 2018 at 5:32:52 PM GMT+2 * · permalink

https://heapanalytics.com/blog/engineering/testing-database-changes-right-way

MySQL 8.0-dev Performance: Scalability & Benchmarks

MySQL · Performance

April 20, 2018 at 4:10:48 PM GMT+2 * · permalink

http://dimitrik.free.fr/Presentations/MySQL_Perf-Benchmarks-PLive_US-Apr.2017-dim.pdf

Chasser les requêtes N+1 avec Bullet

sql · Performance

April 7, 2018 at 11:20:20 AM GMT+2 * · permalink

https://www.synbioz.com/blog/chasser_les_requetes_n+1_avec_bullet

When you execute the same statement thousands of times -> prepare it - Blog dbi services

PostgreSQL · prepare · sql · oltp · Performance

March 26, 2018 at 3:38:48 PM GMT+2 * · permalink

https://blog.dbi-services.com/when-you-execute-the-same-statement-thousands-of-times-prepare-it/

How Partial Indexes Affect UPDATE Performance in Postgres

PostgreSQL · Performance · HoT · index

March 20, 2018 at 2:28:03 PM GMT+1 * · permalink

https://medium.com/@postgresql/how-partial-indexes-affect-update-performance-in-postgres-d05e0052abc

pgcompacttable is a tool for reducing size of bloated tables and indexes without heavy locks.

PostgreSQL · bloat · Performance

March 20, 2018 at 2:20:15 PM GMT+1 * · permalink

https://github.com/dataegret/pgcompacttable

PostgreSQL Query optimization, step by step

PostgreSQL · optimizer · Performance · sql · CTE · RECURSIVE · index · loose_index_scan

March 20, 2018 at 2:18:54 PM GMT+1 * · permalink

https://www.postgresql.eu/events/nordicpgday2018/sessions/session/1858/slides/68/query-optimization-techniques_talk.pdf

PostgreSQL: Speeding up analytics and windowing functions

PostgreSQL · optimizer · Window_function · Performance · sql

March 19, 2018 at 1:16:19 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/postgresql-speeding-up-analytics-and-windowing-functions/

PostgreSQL Meltdown Benchmarks |

PostgreSQL · Performance · Meltdown · Spectre

March 4, 2018 at 2:33:19 PM GMT+1 * · permalink

https://blog.2ndquadrant.com/postgresql-meltdown-benchmarks/