Search: [PostgreSQL] - Anayrat links

Unearthing some hidden PostgreSQL 11 gems - Cybertec

PostgreSQL · pg11

December 27, 2018 at 6:01:31 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/unearthing-some-hidden-postgresql-11-gems/

GitHub - pgcentral/benchmarksql

PostgreSQL · benchmark · TPC

December 27, 2018 at 1:28:18 PM GMT+1 * · permalink

https://github.com/pgcentral/benchmarksql

Database Test Suite

TPC · PostgreSQL · benchmark

December 27, 2018 at 1:15:24 PM GMT+1 * · permalink

https://sourceforge.net/projects/osdldbt/

GitHub - Percona-Lab/tpce-mysql

Malgré le nom, il semble possible de le faire tourner sur PG

benchmark · PostgreSQL · TPC

December 27, 2018 at 1:10:46 PM GMT+1 * · permalink

https://github.com/Percona-Lab/tpce-mysql

Importer OpenFoodFacts dans PostgreSQL

PostgreSQL · SQL · Opendata

December 21, 2018 at 2:38:04 PM GMT+1 * · permalink

http://blog-postgresql.verite.pro/2018/12/21/import-openfoodfacts.html

Benchmark PostgreSQL With Linux HugePages - Percona Database Performance Blog

PostgreSQL · hugepages · linux

December 21, 2018 at 12:39:32 PM GMT+1 * · permalink

https://www.percona.com/blog/2018/12/20/benchmark-postgresql-with-linux-hugepages/

A PostgreSQL story about "NULL IS NULL = NULL AND NOT NULL" - Cybertec

PostgreSQL · NULL · SQL

December 21, 2018 at 12:31:03 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/a-postgresql-story-about-null-is-null-null-and-not-null/

Migration PostgreSQL (presque) sans arrêt de production

PostgreSQL · Replication · logique

December 17, 2018 at 4:08:51 PM GMT+1 * · permalink

http://www.loxodata.com/post/migration_logique/

PostgreSQL major version upgrade using built in Logical Replication

PostgreSQL · logique · Replication · Upgrade

December 14, 2018 at 1:52:49 PM GMT+1 * · permalink

https://www.slideshare.net/AtsushiTorikoshi/postgresql-major-version-upgrade-using-built-in-logical-replication

Architecture & Pitfalls of Logical Replication

PostgreSQL · logique · Replication

December 14, 2018 at 1:52:27 PM GMT+1 * · permalink

https://www.slideshare.net/AtsushiTorikoshi/architecture-pitfalls-of-logical-replication

What the SQL?! JOIN me at UNION Station

SQL · PostgreSQL · UNION

December 14, 2018 at 10:28:36 AM GMT+1 * · permalink

https://ddrscott.github.io/blog/2018/join-me-at-union-station/

What the SQL?!? Recursive

PostgreSQL · SQL · CTE · RECURSIVE

December 14, 2018 at 10:28:11 AM GMT+1 * · permalink

https://ddrscott.github.io/blog/2017/what-the-sql-recursive/

What the SQL?!? WINDOW

SQL · PostgreSQL · Window_function

December 14, 2018 at 10:27:01 AM GMT+1 * · permalink

https://ddrscott.github.io/blog/2017/what-the-sql-window/

What the SQL?!? Lateral Joins

PostgreSQL · Lateral · SQL

December 14, 2018 at 10:26:23 AM GMT+1 * · permalink

https://ddrscott.github.io/blog/2017/what-the-sql-lateral/

Bloat and Fragmentation in PostgreSQL

HoT · Vacuum · PostgreSQL

December 12, 2018 at 1:29:54 PM GMT+1 * · permalink

https://www.slideshare.net/masahikosawada98/bloat-and-fragmentation-in-postgresql

Hooks in PostgreSQL

hook · PostgreSQL · Internal · hack

December 11, 2018 at 12:20:14 PM GMT+1 * · permalink

https://www.pgcon.org/2012/schedule/attachments/243_Hooks%20in%20PostgreSQL

GitHub - AmatanHead/psql-hooks: Unofficial documentation for PostgreSQL hooks.

hook · PostgreSQL · hack · Internal

December 11, 2018 at 12:19:54 PM GMT+1 * · permalink

https://github.com/AmatanHead/psql-hooks

prepared transactions and their dangers - Cybertec

2PC · prepare · PostgreSQL

December 11, 2018 at 11:45:29 AM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/prepared-transactions/

Kubernetes in Production: Services – okmeter.io blog

Kubernetes · PostgreSQL

December 10, 2018 at 2:31:22 PM GMT+1 * · permalink

https://blog.okmeter.io/kubernetes-in-production-services-34c3234c94c8

Pagination Done the PostgreSQL Way

PostgreSQL · SQL · pagination · offset

December 10, 2018 at 1:46:41 PM GMT+1 * · permalink

https://leopard.in.ua/2014/10/11/postgresql-paginattion#.XA5gDk6Z3mE