This post covers PostgreSQL 18’s performance improvements on Amazon Aurora and Amazon RDS, including skip scan optimization for multicolumn indexes, enhanced EXPLAIN output with automatic buffer statistics, and automatic removal of unnecessary self-joins. It also details improved autovacuum controls such as the autovacuum_vacuum_max_threshold parameter and vacuum_truncate as a server-wide setting to optimize query performance and maintenance efficiency.
Discovery
Learnings
- auto_storiesStories
- categoryAreas
- helpFAQ
- forumConversations
- descriptionPapers
- mailNewsletters
- video_libraryVideos
- timelineTimeline
Guidance
- codeTechnology of APIs
- business_centerBusiness of APIs
- campaignEvangelism of APIs
- gavelGovernance of APIs
- historyHistory of APIs
- account_balancePolitics of APIs
Toolbox
- domainProviders
- apiAPIs
- cloudSolutions
- buildTools
- verifiedStandards
- gavelRegulations
- horizontal_ruleHeaders
- layersOverlays
- extensionExtensions
- schemaSchema
- policyPolicies
- ruleRules