Artwork

Content provided by Project Geospatial. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Project Geospatial or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.
Player FM - Podcast App
Go offline with the Player FM app!

FOSS4G NA 2024 - Postgres and PostGIS Ops Management - Elizabeth Christensen

22:45
 
Share
 

Manage episode 461965964 series 3234430
Content provided by Project Geospatial. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Project Geospatial or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.

Elizabeth Christensen discusses effective management of Postgres and PostGIS databases, focusing on operations, resource management, and the importance of indexing. Highlights πŸ“Š Postgres versions: Upgrade to 14, 15, or 16 for better performance. ☁️ Hosting options: Choose between self-managing or fully managed cloud services. πŸ“ˆ Memory matters: Allocate sufficient memory for optimal database performance. πŸ” Indexing importance: Essential for efficient spatial data querying. πŸ› οΈ Monitoring: Set up proper logging and monitoring systems for performance insights. πŸ’» Free resources: Check out learn.crunchydata.com for tutorials on SQL and PostGIS. πŸ”„ Regular updates: Keep up with quarterly maintenance versions for security and performance. For more content like this check out www.projectgeospatial.com #Postgres #PostGIS #DatabaseManagement #OpenSource #TechTalk #FOSS4G #DataScience

  continue reading

362 episodes

Artwork
iconShare
 
Manage episode 461965964 series 3234430
Content provided by Project Geospatial. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Project Geospatial or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.

Elizabeth Christensen discusses effective management of Postgres and PostGIS databases, focusing on operations, resource management, and the importance of indexing. Highlights πŸ“Š Postgres versions: Upgrade to 14, 15, or 16 for better performance. ☁️ Hosting options: Choose between self-managing or fully managed cloud services. πŸ“ˆ Memory matters: Allocate sufficient memory for optimal database performance. πŸ” Indexing importance: Essential for efficient spatial data querying. πŸ› οΈ Monitoring: Set up proper logging and monitoring systems for performance insights. πŸ’» Free resources: Check out learn.crunchydata.com for tutorials on SQL and PostGIS. πŸ”„ Regular updates: Keep up with quarterly maintenance versions for security and performance. For more content like this check out www.projectgeospatial.com #Postgres #PostGIS #DatabaseManagement #OpenSource #TechTalk #FOSS4G #DataScience

  continue reading

362 episodes

All episodes

×
 
Loading …

Welcome to Player FM!

Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.

 

Quick Reference Guide

Listen to this show while you explore
Play