نقشه راه PostgreSQL DBA

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

عمومی

سطح

امیر دایی

مدرس

5

1 رای

308

بازدید

0

دیدگاه

Advanced TopicssysstatGiSTRelationsHashSecuritykaar2.irMigration Related ToolsCheckpoints / Background WriterPgBouncer AlternativesBRINLoad Balancing / DiscoveryWAL-GData TypesStorage ParametersReporting Logging & StatisticspgbackrestUsing DockerDeployment in CloudChefPosgres ToolsManaging PostgresBackup & Recovery ToolsDevOps RoadmapMailing ListsNULLPEV2Write-ahead LogACIDWrite-ahead LogRecursive CTEReplicationUsing `pg_ctl`MVCCPgBouncerLearn SQLPractical Patterns / AntipatternstemBoardCluster ManagementMonitoringQuerying DataConnection PoolingRow-Level SecurityHigh Level Database ConceptsApplicationSkillsBulk Loading / Processing DatastracegrepCore DumpsUsing `pg_upgrade`Shell ScriptsAdvanced TopicsColumnsPostgreSQL vs NoSQL DatabasesFiltering Datacheck_pgbackrestIndexes and their UsecasesVacuum ProcessingMigrationsDatabasesPuppetLearn to AutomateSSL SettingsWriting PatchesNormalization / Normal FormsSchema Design Patterns / Anti-patternsDML QueriesTechniquesGINWorkload-Dependant TuningCTEInstallation and SetupLateral JoinData TypesAdvanced SQLModifying DataSQL Query Patterns / Anti-patternsForTablesAuthentication ModelsMongoDBTransactionsSELinuxPhysical Storage and File LayoutDDL QueriesKubernetes DeploymentBuiltin ToolsawkQuery PlannerJoining TablessedPostgreSQL vs Other RDBMSpg_probackupConsulPostgreSQLAggregate and Window functionspgCluuAny Programming LanguageConstraintsAdvanced TopicsB-TreeData and ProcessingReviewing PatchesQuery AnalysisEtcdBuffer ManagementFor SchemasSet OperationsRolesIntroductionSystem CatalogProcedures and FunctionsSP-GiSTDomainsBasic RDBMS ConceptsUpgrade ProceduresRelational ModelSchemasAnonymizationPatroniConnect using `psql`Per-User, Per-Database SettingUsing Logical ReplicationStreaming ReplicationEXPLAINiotopGet Involved in Developmentpg_stat_activityOperatorsGrant / RevokeConfiguration ManagementData PartitioningReplicationGolden SignalsUsing `systemd`RDBMS Benefits and LimitationsPackage ManagersLock ManagementTriggerstopebpfSaltREDHelmQuery Processingpg_dumpallUSESharding PatternsRowsHTAPLogical ReplicationSimple Stateful SetupPatterns / AntipatternsObject ModelAnsibleDepeszObject PrivilegesPosgres System ViewsResource Usage / Provisioning / Capacity PlanningWhat are Relational Databases?Visit the following relevant roadmapsDefault PrivilegesConfiguringBackup Validation ProceduresFine-grained TuningpgcenterPatroni AlternativesImport / Export Using `COPY`PL/pgSQLBackendLog AnalysisGroupingexplain.dalibo.compgBadgerProcesses & Memory ArchitectureUsing `pg_ctlcluster`HAProxyAdding Extra ExtensionsOLTPTuplesTablesPgQperf-toolsOLAPcheck_pgactivitypg_stat_statementsOperating System ToolsFollowing postgres.confconfigurationLow Level InternalsQueuesRELATED ROADMAPS› MongoDB Roadmap› Backend RoadmapTensorbarmanKeepAlivedPrometheusSQL Optimization TechniquesQueriesAttributespg_basebackuppg_dumppg_hba.confTransactionsFind the detailed version of this roadmapalong with other similar roadmapsgdbTroubleshooting TechniquesResource UsageSubqueriespg_restorePostgreSQL AnonymizerZabbixProfiling ToolsInfrastructure SkillsVacuums3rd Party