Sign up to save your podcasts
Or
Share FOSS4G NA 2024 - Postgres and PostGIS Ops Management - Elizabeth Christensen
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
FOSS4G NA 2024 - Postgres and PostGIS Ops Management - Elizabeth Christensen
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
View all episodes
By Project Geospatial
5
33 ratings
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
More shows like Project Geospatial
View all
The MapScaping Podcast - GIS, Geospatial, Remote Sensing, earth observation and digital geography
112 Listeners