pugtalkmarch25.pdf

Transcript

1. Boston Postgres Users Group Lightning talks Boston Postgres User Group Lightning Talks March 25, 2019 Amazon Boston 27 Melcher Street, Boston MA
2. Boston Postgres Users Group Lightning talks THE RULES -Talk about anything for 5 minutes -Includes time for questions -Hard Stop at 5 minutes mark (that is part of the fun). -Warnings at 90 seconds, 1 minute, 30 seconds, 10 seconds
3. Boston Postgres Users Group Lightning talks THE Talks Tom Kincaid - 5 Postgres Parameters you should always tune Jesper Pedersen - Analyzing Application Performance Jim Finnerty - Status of Pluggable Storage Seth Proctor - Tranquil Data Paul Harrington – Foreign Eka Palamadai - Serverless Aurora PostgreSQL Braulio Carreno - Small Dollar Fundraising Zheng Li - NOT IN subquery optimization Josh Kupershmidt - Code Smells Database Edition
4. Talk number 1: Top 5 tuning parameters • shared_buffers • work_mem • maitenance_work_mem • vacuum_cost_limit • random_page_cost