Anayrat links

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

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

GitHub - dataegret/pg-utils: Useful PostgreSQL utilities

PostgreSQL · Tricks

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

https://github.com/dataegret/pg-utils

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

Smart indexing of json - pgconfRU 2018

PostgreSQL · index · JSON · Opclass

March 20, 2018 at 11:01:11 AM GMT+1 * · permalink

http://www.sai.msu.su/~megera/postgres/talks/opclass_pgconf.ru-2018.pdf

Peter Geoghegan's blog: Decoding pg_filenode.map files with pg_filenodemapdata

PostgreSQL · Hack · Internal

March 20, 2018 at 8:37:25 AM GMT+1 * · permalink

http://pgeoghegan.blogspot.fr/2018/03/decoding-pgfilenodemapdata.html

Database constraints in Postgres: The last line of defense

PostgreSQL · constraint · sql

March 19, 2018 at 6:37:20 PM GMT+1 * · permalink

https://www.citusdata.com/blog/2018/03/19/postgres-database-constraints/