سطح عمومی

نقشه راه PostgreSQL DBA

Step by step guide to becoming a modern PostgreSQL DB Administrator in 2025

طراحی و تدوین مسیر

امیر دایی

محتوای مسیر
۱۷۰ گام آموزشی
رضایت یادگیرندگان
۵ از ۵(۱ رأی)
همراهان این مسیر
اولین نفر باشید
نظرتان درباره‌ی این مسیر؟
اولین دیدگاه را بنویسید
Fine-grained TuningPostgreSQLFind the detailed version of this roadmapalong with other similar roadmapskaar2.irIntroductionWhat are Relational Databases?RDBMS Benefits and LimitationsPostgreSQL vs Other RDBMSPostgreSQL vs NoSQL DatabasesBasic RDBMS ConceptsObject ModelQueriesData TypesRowsColumnsTablesSchemasDatabasesRelational ModelDomainsAttributesTuplesRelationsConstraintsNULLHigh Level Database ConceptsACIDMVCCTransactionsWrite-ahead LogQuery ProcessingUsing DockerPackage ManagersConnect using `psql`Deployment in CloudManaging PostgresUsing `systemd`Using `pg_ctl`Using `pg_ctlcluster`Installation and SetupLearn SQLDDL QueriesFor SchemasForTablesData TypesDML QueriesQuerying DataFiltering DataModifying DataJoining TablesImport / Export Using `COPY`TransactionsSubqueriesGroupingCTELateral JoinSet OperationsAdvanced TopicsConfiguringResource UsageWrite-ahead LogVacuumsReplicationQuery PlannerCheckpoints / Background WriterReporting Logging & StatisticsAdding Extra ExtensionsFollowing postgres.confconfigurationSecurityObject PrivilegesGrant / RevokeDefault PrivilegesAdvanced TopicsRow-Level SecuritySELinuxAuthentication ModelsRolespg_hba.confSSL SettingsInfrastructure SkillsUsing `pg_upgrade`Using Logical ReplicationSimple Stateful SetupHelmOperatorsPostgreSQL AnonymizerHAProxyConsulKeepAlivedEtcdPrometheusZabbixcheck_pgactivitytemBoardcheck_pgbackrestbarmanWAL-Gpgbackrestpg_probackuppg_dumppg_dumpallpg_restorepg_basebackupBackup Validation ProceduresPgBouncerPgBouncer AlternativesConnection PoolingLogical ReplicationStreaming ReplicationReplicationAnonymizationUpgrade ProceduresCluster ManagementPatroniPatroni AlternativesKubernetes DeploymentMonitoringLoad Balancing / DiscoveryBackup & Recovery Tools3rd PartyBuiltin ToolsResource Usage / Provisioning / Capacity PlanningLearn to AutomateShell ScriptsAny Programming LanguageConfiguration ManagementAnsibleSaltChefPuppetMigrationsPractical Patterns / AntipatternsMigration Related ToolsBulk Loading / Processing DataData PartitioningSharding PatternsNormalization / Normal FormsQueuesPatterns / AntipatternsPgQData and ProcessingApplicationSkillsAdvanced TopicsLow Level InternalsProcesses & Memory ArchitectureVacuum ProcessingBuffer ManagementLock ManagementPhysical Storage and File LayoutSystem CatalogPer-User, Per-Database SettingStorage ParametersWorkload-Dependant TuningOLTPOLAPHTAPPL/pgSQLProcedures and FunctionsTriggersRecursive CTEAggregate and Window functionsAdvanced SQLTroubleshooting TechniquesOperating System ToolstopsysstatiotopProfiling Toolsgdbstraceebpfperf-toolsCore DumpsLog AnalysispgBadgerpgCluuawkgrepsedPosgres System Viewspg_stat_activitypg_stat_statementsPosgres ToolspgcenterQuery AnalysisEXPLAINDepeszPEV2Tensorexplain.dalibo.comTechniquesUSEREDGolden SignalsSQL Optimization TechniquesSchema Design Patterns / Anti-patternsSQL Query Patterns / Anti-patternsIndexes and their UsecasesB-TreeHashGiSTSP-GiSTGINBRINGet Involved in DevelopmentMailing ListsReviewing PatchesWriting PatchesRELATED ROADMAPS› MongoDB Roadmap› Backend RoadmapVisit the following relevant roadmapsMongoDBBackendDevOps Roadmap