Anayrat links

PostgreSQL Data Types: Date, Timestamp, and Time Zones

April 18, 2018 at 11:23:39 AM GMT+2 * · permalink

https://tapoueh.org/blog/2018/04/postgresql-data-types-date-timestamp-and-time-zones/

New zine: Profiling & tracing with perf!! - Julia Evans

perf

April 17, 2018 at 1:53:35 PM GMT+2 * · permalink

https://jvns.ca/blog/2018/04/16/new-perf-zine/

PostgreSQL Data Types: Network Addresses

PostgreSQL · inet · types

April 16, 2018 at 5:32:41 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/04/postgresql-data-types-network-addresses/

Ceph: how to test if your SSD is suitable as a journal device? | Sébastien Han

fio · SSD

April 16, 2018 at 11:04:21 AM GMT+2 * · permalink

https://www.sebastien-han.fr/blog/2014/10/10/ceph-how-to-test-if-your-ssd-is-suitable-as-a-journal-device/

Shichao's Notes

Kernel · linux · Internal · Hack

April 16, 2018 at 10:35:35 AM GMT+2 * · permalink

https://notes.shichao.io/

Design Principles for Scaling Multi-core OLTP Under High Contention

database · Publication · not_read

April 14, 2018 at 3:20:28 PM GMT+2 * · permalink

http://cs-www.cs.yale.edu/homes/dna/papers/orthrus-sigmod16.pdf

PostgreSQL Data Types: Text Processing

PostgreSQL · sql · types

April 12, 2018 at 9:56:12 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/04/postgresql-data-types-text-processing/

Effects of CPU caches – Nicolas Douillet – Medium

CPU · Cache · perf

April 12, 2018 at 9:55:44 PM GMT+2 * · permalink

https://medium.com/@minimarcel/effect-of-cpu-caches-57db81490a7f

index maintenance - Get rid of your unused indexes! - Cybertec

PostgreSQL · index

April 12, 2018 at 2:57:51 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/get-rid-of-your-unused-indexes/

Postgres 10 Upgrade

PostgreSQL · amcheck · Upgrade · pg_catcheck

April 11, 2018 at 6:48:20 PM GMT+2 * · permalink

https://bricklen.github.io/2018-03-27-Postgres-10-upgrade/

Postgres 11 highlight - Covering Indexes

PostgreSQL · index

April 11, 2018 at 6:47:30 PM GMT+2 * · permalink

http://paquier.xyz/postgresql-2/postgres-11-covering-indexes/

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

PostgreSQL Data Types: an intro

sql · PostgreSQL · types

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

https://tapoueh.org/blog/2018/04/postgresql-data-types-an-intro/

Advanced SQL: Why first_value and last_value are no bugs - Cybertec

PostgreSQL · sql · Window_function

April 2, 2018 at 6:10:50 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/advanced-sql-why-first_value-and-last_value-are-no-bugs/

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/

Être une entreprise libérée, tu sais c’est pas si facile…

SCOP · Entreprise_libérée · gouvernance

March 26, 2018 at 11:49:51 AM GMT+2 * · permalink

https://medium.com/one-more-thing-studio/etre-une-entreprise-liberee-5d28ba14a4d2

Object Relational Database Management System

PostgreSQL · sql

March 24, 2018 at 3:54:17 PM GMT+1 * · permalink

https://tapoueh.org/blog/2018/03/object-relational-database-management-system/

Walking with the Elephant: Containing bloat with partitions

PostgreSQL · bloat · partionning

March 24, 2018 at 3:53:52 PM GMT+1 * · permalink

http://ashutoshpg.blogspot.fr/2018/03/containing-bloat-with-partitions.html

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

Data Modeling, Normalization and Denormalization

PostgreSQL · normalisation · sql

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

https://tapoueh.org/images/confs/NordicPGDAY_2018.pdf