Search: [PostgreSQL] - Anayrat links

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/

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/

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/

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/

create-statistics-talk/create-statistics-what-is-it.pdf at master · tvondra/create-statistics-talk · GitHub

PostgreSQL · Statistics

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

https://github.com/tvondra/create-statistics-talk/blob/master/create-statistics-what-is-it.pdf

Using pg_badplan to CREATE STATISTICS is a good plan | Joel on SQL

PostgreSQL · Statistics · pg_badplan · extension

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

https://joelonsql.com/2018/03/19/using-pg_badplan-to-create-statistics-is-a-good-plan/

Repeatable Read Is Not Repeatable – Database Journal Club – Medium

PostgreSQL · Isolation · sql

March 17, 2018 at 5:01:40 PM GMT+1 * · permalink

https://medium.com/db-journal/repeatable-read-is-not-repeatable-c700b2ce1c76

SQL/JSON standard-2016 conformance for PostgreSQL, Oracle, SQL Server and MySQL - ...

PostgreSQL · JSON

March 16, 2018 at 3:39:51 PM GMT+1 * · permalink

https://obartunov.livejournal.com/200076.html

Migrating our production deployment from MariaDB Galera to PostgreSQL and Patroni - pretix – behind the scenes - Behind the scenes of pretix, your friendly open source ticketing system from next door. Might contain traces of technology and business.

PostgreSQL · MySQL · MariaDB · Patroni · HA

March 16, 2018 at 3:27:22 PM GMT+1 * · permalink

https://behind.pretix.eu/2018/03/11/mysql-to-postgres/