Search: [PostgreSQL] - Anayrat links

PostgreSQL Updatable Views: Performing Schema Updates With Minimal Downtime - Percona Database Performance Blog

PostgreSQL · view

January 10, 2019 at 5:56:47 PM GMT+1 * · permalink

https://www.percona.com/blog/2019/01/10/postgresql-updatable-views-performing-schema-updates-with-minimal-downtime/

Bring native psql magic into Jupyter Notebook – Constantinos Antzakas – Medium

PostgreSQL · Jupyter

January 10, 2019 at 5:56:31 PM GMT+1 * · permalink

https://medium.com/@cantzakas/bring-native-psql-magic-into-jupyter-notebook-50b663d856b5

Looking Back at Postgres

PostgreSQL

January 10, 2019 at 4:32:18 PM GMT+1 * · permalink

http://www.morganclaypoolpublishers.com/stonebraker/5-Hellerstein.pdf

Looking Back at Postgres

PostgreSQL

January 10, 2019 at 4:25:10 PM GMT+1 * · permalink

https://arxiv.org/pdf/1901.01973.pdf

PG 11 Partitioning Optimization Features · GitHub

PostgreSQL · pg11 · partionning

January 10, 2019 at 4:23:46 PM GMT+1 * · permalink

https://gist.github.com/amitlan/cd13271142bb2d26ae46b69afb675a31

GitHub - erthalion/postgres-bcc

bcc · eBPF · Performance · PostgreSQL · Internal

January 9, 2019 at 3:30:22 PM GMT+1 * · permalink

https://github.com/erthalion/postgres-bcc

Inlining of SQL functions - PostgreSQL wiki

PostgreSQL · functions

January 8, 2019 at 4:43:19 PM GMT+1 * · permalink

https://wiki.postgresql.org/wiki/Inlining_of_SQL_functions

How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage | Haki Benita

PostgreSQL · SQL · tuning

January 3, 2019 at 9:27:48 AM GMT+1 * · permalink

https://hakibenita.com/how-we-solved-a-storage-problem-in-postgre-sql-without-adding-a-single-bytes-of-storage

Subtleties of time zone calculations in Postgres // CY Tech

PostgreSQL · time · SQL

December 28, 2018 at 2:40:30 PM GMT+1 * · permalink

https://tech.codeyellow.nl/blog/pg-timezones/

Lies, damned lies, and statistics

PostgreSQL · Statistics

December 28, 2018 at 12:35:22 PM GMT+1 * · permalink

https://www.pgcon.org/2017/schedule/attachments/443_lies-damned-lies-and-statistics.pdf

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