The postgres trajectory.pdf

1、The Postgres TrajectoryBRUCEMOMJIANThis talk explores Postgress two strengths,open source and extendibility.https:/momjian.us/presentationsCreative Commons Attribution LicenseLast updated:June 20251/16Is Open Source As Good As Proprietary Software?TimeOpen SourceClosed SourceFeaturesPerformanceRelia

2、bility2/16Proprietary Software DevelopmentDevelopersUsersSalesTesting/RetestingReleaseFix BugsProject MeetingsDesign MeetingsWork in IsolationReceive SoftwareAcceptance TestsResolve ProblemsInstallProductionResolve Issues3/16Open Source DevelopmentUsersInternetDevelopersProductionDiscuss FeatureRele

3、aseBeta TestingFix BugsPatch ReviewApply/TestingResolve IssuesPropose FeatureTestingPatch ReviewBeta Testing4/16Advantages of Open Source1.Innovation,competitive features2.Freedom from vendor lock-in3.Quality of solutions4.Ability to customize and fix5.Cost(initially#1)6.Speed application developmen

4、t7.Reduce development costs8.Interoperability9.Breadth of solutionshttps:/ attained feature parity withHP-UXAIXSolarisand then went on to innovate beyond them.6/16Open Source WorldSoftwareOpen SourcePostgreSQL7/16PostgresPostgres nearing feature parity with:1.Oracle2.DB23.MS-SQL4.Sybase5.Informix6.I

5、ngres Corp.and then going on to innovate beyond them.8/16More InformationFor more information about open source,seeWill Postgres Live Forever?https:/momjian.us/main/presentations/open_source.html#foreverThe Democratization of Databaseshttps:/momjian.us/main/presentations/open_source.html#democratiza

6、tion9/16Extendibility:The University YearsDesigned for Extendibility in 1986Ignored in 1996Praised for its Extendibility todayMichael Stonebraker10/16How Is Postgres Relational+?Extendibility is built in:Data typesIndexing methods,not just btreeFunctionsOperatorsServer-side langu