Search: [PostgreSQL] - Anayrat links

Illuminated Computing | Lateral Join Alternatives

PostgreSQL · SQL · Lateral

October 22, 2018 at 19:03:45 GMT+2 * · permalink

https://illuminatedcomputing.com/posts/2015/02/lateral_join_alternatives/

The Art of Database Experiments – PostgresConf Silicon Valley 2018 / …

PostgreSQL · benchmark · Performance · tests

October 18, 2018 at 11:12:33 GMT+2 * · permalink

https://www.slideshare.net/samokhvalov/the-art-of-database-experiments-postgresconf-silicon-valley-2018-san-jose

Inheriting super user privileges over a role automatically in PostgreSQL - Blog dbi services

PostgreSQL · Security · roles

October 17, 2018 at 09:58:59 GMT+2 * · permalink

http://blog.dbi-services.com/inheriting-super-user-privileges-over-a-role-automatically-in-postgresql/

Leveraging Query Parallelism In PostgreSQL

PostgreSQL · Parallel · Performance

October 16, 2018 at 17:16:45 GMT+2 * · permalink

http://2019.pgconf.in/wp-content/uploads/D121-Dilip-Kumar-Leveraging-intra-query-parallelism-in-PostgreSQL.pdf

PostgreSQL migration from AWS RDS to EC2

PostgreSQL · AWS · RDS · EC2

October 16, 2018 at 16:40:15 GMT+2 * · permalink

http://2019.pgconf.in/wp-content/uploads/D115-Hitul-Mistry-PostgreSQL-migration-from-AWS-RDS-to-EC2.pdf

Query Optimizations For Partitioned Tables

PostgreSQL · partionning

October 16, 2018 at 16:06:59 GMT+2 * · permalink

http://2019.pgconf.in/wp-content/uploads/D125-Ashutosh-Bapat-Query-optimization-techniques-for-declarative-partitioning.pdf

Ideas for scaling PostgreSQL to multi-terabyte and beyond - Cybertec

PostgreSQL · index · GIN · Btree · BRIN · Bloom · FDW

October 16, 2018 at 14:45:24 GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/ideas-for-scaling-postgresql-to-multi-terabyte-and-beyond/

How to Manage Connections Efficiently in Postgres, or Any Database — Brandur Leach

PgBouncer · PostgreSQL

October 15, 2018 at 20:12:00 GMT+2 * · permalink

https://brandur.org/postgres-connections

DAT302_Deep Dive on Amazon Relational Database Service (RDS)

AWS · RDS · PostgreSQL

October 15, 2018 at 12:08:27 GMT+2 * · permalink

https://fr.slideshare.net/AmazonWebServices/dat302deep-dive-on-amazon-relational-database-service-rds

Amazon Aurora Postgres: First thoughts

Retour d'expérience

AWS · Aurora · PostgreSQL

October 15, 2018 at 10:58:58 GMT+2 * · permalink

https://www.linkedin.com/pulse/amazon-aurora-postgres-first-thoughts-eric-green/

Amazon Aurora with PostgreSQL Compatibility | Hacker News

Voir les commentaires pour les retours d'expérience

AWS · Aurora · PostgreSQL

October 15, 2018 at 10:58:12 GMT+2 * · permalink

https://news.ycombinator.com/item?id=15546328

Migrating a live Postgres database into RDS with no downtime Experiences and Lessons Learned

RDS · PostgreSQL · AWS

October 15, 2018 at 10:57:35 GMT+2 * · permalink

https://wiki.postgresql.org/images/d/da/PGConfUS2016_Migrating_a_live_Postgres_database_into_RDS_with_no_downtime.pdf

A Replication Cheat-Sheet

pas mal de retours d’expérience et de limitations sur RDS/aurora

RDS · AWS · PostgreSQL

October 15, 2018 at 10:56:41 GMT+2 * · permalink

https://thebuild.com/blog/2018/01/02/a-replication-cheat-sheat/

PostgreSQL on AWS: Tips & Tricks (and horror stories)

AWS · RDS · PostgreSQL

October 15, 2018 at 10:56:19 GMT+2 * · permalink

https://fr.slideshare.net/AlexanderKukushkin1/postgresql-on-aws-tips-tricks-and-horror-stories

Deep Dive on the Amazon Aurora PostgreSQL-compatible Edition - DAT402… - AWS Reinvent 2017

AWS · Aurora · PostgreSQL

October 15, 2018 at 10:55:15 GMT+2 * · permalink

https://fr.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-postgresqlcompatible-edition-dat402-reinvent-2017

SRV310 Optimizing Relational Databases on AWS: Deep Dive on Amazon R… - AWS Summit 2018

PostgreSQL · Aurora · AWS · RDS

October 15, 2018 at 10:37:39 GMT+2 * · permalink

https://fr.slideshare.net/AmazonWebServices/srv310-optimizing-relational-databases-on-aws-deep-dive-on-amazon-rds

SRV308 Deep Dive on Amazon Aurora - AWS Summit 2018

Aurora · PostgreSQL · AWS

October 15, 2018 at 10:32:48 GMT+2 * · permalink

https://fr.slideshare.net/AmazonWebServices/srv308-deep-dive-on-amazon-aurora

Part II – Playing around with Linux perf events and Flame Graphs on PostgreSQL – The little things about databases….

PostgreSQL · perf · flamegraph

October 12, 2018 at 13:18:47 GMT+2 * · permalink

https://newbiedba.wordpress.com/2018/10/12/part-ii-playing-around-with-linux-perf-events-and-flame-graphs-on-postgresql/

Won’t You Be My Neighbor? Quickly Finding Who is Nearby

PostgreSQL · GiST · KNN

October 11, 2018 at 13:47:21 GMT+2 * · permalink

https://info.crunchydata.com/blog/wont-you-be-my-neighbor-quickly-finding-who-is-nearby

Managing Freezing in PostgreSQL

Vacuum · freeze · PostgreSQL

October 10, 2018 at 15:30:09 GMT+2 * · permalink

https://blog.2ndquadrant.com/managing-freezing/