Search: [PostgreSQL] - Anayrat links

PostgreSQL Data Types: Text Encoding

types · PostgreSQL · Encoding

April 18, 2018 at 12:24:08 PM GMT+2 * · permalink

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

the ultimate postgres vs mysql blog post | dian m fay

MySQL · PostgreSQL

April 18, 2018 at 12:11:52 PM GMT+2 * · permalink

https://di.nmfay.com/postgres-vs-mysql

PostgreSQL Data Types: Date and Time Processing

PostgreSQL · sql · types · time

April 18, 2018 at 12:08:59 PM GMT+2 * · permalink

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

PostgreSQL Data Types: Date, Timestamp, and Time Zones

PostgreSQL · sql · types · time

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/

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/

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/

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/

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