Search: [PostgreSQL] - Anayrat links

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

AWS · RDS · PostgreSQL

October 15, 2018 at 10:56:19 AM 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 AM 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 AM 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 AM 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 1:18:47 PM 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 1:47:21 PM 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 3:30:09 PM GMT+2 * · permalink

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

Debugging the Postgres Planner

https://github.com/melanieplageman/debugging_planner/blob/master/debugging_planner_pgopen_FINAL.pdf

PostgreSQL · Internal · planner

October 9, 2018 at 11:29:59 AM GMT+2 * · permalink

https://www.youtube.com/watch?v=9Sx1CChuyGE

2018-10-04 Meetup PG Nantes - PostgreSQL: Estimer la mémoire nécessai…

PostgreSQL · sort

October 9, 2018 at 9:23:32 AM GMT+2 * · permalink

https://www.slideshare.net/rjuju/20181004-meetup-pg-nantes-postgresql-estimer-la-mmoire-ncessaire-pour-un-tri

Achieving PCI Compliance with Postgres

PostgreSQL · Encryption · pcidss

October 8, 2018 at 11:26:26 AM GMT+2 * · permalink

https://pgconf.ru/media2015c/patel.pdf

Explaining CREATE INDEX CONCURRENTLY |

PostgreSQL · index · HoT

October 4, 2018 at 1:00:07 PM GMT+2 * · permalink

https://blog.2ndquadrant.com/create-index-concurrently/

Towards ACID scalable PostgreSQL with partitioning and logical replication

PostgreSQL · HA · CSN

October 4, 2018 at 12:57:37 PM GMT+2 * · permalink

https://www.pgcon.org/2018/schedule/attachments/498_Towards%20scalable%20ACID%20PostgreSQL%20with%20pg_shardman

Parallelism and Partitioning - Improvements in Postgres 11 | EnterpriseDB

PostgreSQL · partionning · pg11 · Parallel

October 3, 2018 at 12:38:15 PM GMT+2 * · permalink

https://www.enterprisedb.com/blog/parallelism-and-partitioning-improvements-postgres-11

Bloom index for bigint - ...

PostgreSQL · Opclass · Bloom · index

October 3, 2018 at 9:28:35 AM GMT+2 * · permalink

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

pgCenter - stress free Postgres stats.

PostgreSQL · monitoring

October 3, 2018 at 9:10:06 AM GMT+2 * · permalink

http://blog.dataegret.com/2018/10/pgcenter-stress-free-postgres-stats.html

Sequence Caching: Oracle vs. PostgreSQL

PostgreSQL · MVCC · sequence

October 3, 2018 at 9:09:46 AM GMT+2 * · permalink

https://seiler.us/2018-10-02-sequence-caching-oracle-vs-postgresql/

select * from depesz; » Blog Archive » Foreign Key to partitioned table

PostgreSQL · Trigger · fk · partionning

October 2, 2018 at 12:53:35 PM GMT+2 * · permalink

https://www.depesz.com/2018/10/02/foreign-key-to-partitioned-table/

SELECT DISTINCT ON in PostgreSQL | Geeky Tidbits

PostgreSQL · SQL

October 1, 2018 at 9:10:17 PM GMT+2 * · permalink

https://www.geekytidbits.com/postgres-distinct-on/

Per-Table Autovacuum Tuning at Keith's Ramblings…

PostgreSQL · Vacuum

October 1, 2018 at 9:10:03 PM GMT+2 * · permalink

https://www.keithf4.com/per-table-autovacuum-tuning/

Query Execution Techniques in PostgreSQL

PostgreSQL · executor · Internal · planner

September 30, 2018 at 7:51:38 PM GMT+2 * · permalink

http://www.neilconway.org/talks/executor.pdf