SPOILER ALERT!
So as to let much more good friends understand PostgreSQL, I've produced the use and analysis of PG in these years into some method training videos and some specific videos. (Totally free viewing and downloading) I hope to assist some good friends by way
Please indicate the source.
In response to feedback from some netizens, the redesigned instruction content is as follows, from shallow to deep, appropriate for distinct groups of people today. Like PostgreSQL improvement approach, neighborhood introduction, resource introduction 2 hours PostgreSQLSQL basics 2 days PostgreSQL database management three days PostgreSQL database backup and recovery, data Replication, load balancing and higher availability 3 days PostgreSQL server programming 3 days PostgreSQL overall performance optimization three days PostgreSQL major data application 3 days PostgreSQL kernel two days PostgreSQL application case n days Individual technical level is restricted, application case training invites knowledgeable technology Employees sharing to expand the application, such as game developers, developers of massive information analysis goods, and so on.
The detailed course content material is as follows: PostgreSQL improvement method, neighborhood introduction, resource introduction 2 hours
PostgreSQLSQL foundation two days The initial day of PostgreSQL installation, architecture foundation introduction, ways to build and access the database; SQL language foundation (create tables, manipulate table information, table association queries, aggregate queries); SQL sophisticated applications (views, foreign keys, transactions , Window function, inheritance); SQL semantic structure introduction (keywords and phrases, constants, operators, particular characters, comments, operator priority); worth expression introduction (columns, positional parameters, array subscripts, field references, operations Contact, function get in touch with, aggregate expression, window function call, sort conversion, collate expression, normal quantum query, array constructor, row constructor, expression logic operation rules); function get in touch with usage introduction (positional parameter contact, naming Parameter get in touch with, mixed get in touch with); information definition (default values, constraints, technique columns, table structure and definition modification, permissions, schema, inheritance, partition, external data); data query the subsequent day (from clause, where clause, groupbyhaving clause, window clause, select clause, outcome set operation, sorting, limit, displacement, values clause, CET usage); data kind (number, currency, character, byte, time, boolean, enumeration, geometry , Net, bit, text search, UUID, XML, JSO N, array, composite variety, variety form, object variety, pseudo type); functions and operators (logic, comparison, mathematical operations, strings, byte streams, bits, pattern matching, formatting, time, enumeration, Geometry, network, full-text search, XML, JSON, sequence, situation, array, variety, aggregation, window, subquery, row and array comparison, SRF function, program data function, program management function, trigger function, event trigger Function); variety conversion; index usage; full-text retrieval usage; parallel handle; SQL efficiency optimization;
PostgreSQL database management 3 days initially day PostgreSQL supply code installation (source structure introduction, configuration introduction, custom FLAG introduction, kernel parameter optimization, installation); database server configuration (OSUSER, initial cluster, start off database cluster, close database cluster, upgrade Database software program, anti-spoofing, information encapsulation method, SSL, SSH tunnel) Introduction to database cluster procedure structure (postmaster, logger, checkpointer, writer, walwriter, autovacuumlauncher, autovacuumworker, statscollector, backend, worker); authentication and connection (client authentication system Introduction, authentication configuration, frequent authentication method usage examples, typical authentication errors troubleshooting); pgAdminIII usage introduction (installation, use, debugging functions, upkeep information); database configuration (guc.c, parameter priority, parameter which means, improvement parameters, GUC implied parameters, how you can modify the parameters and make them productive, how you can view the present parameter values, ways to view the array of parameter values); user management (making roles, role permission management, function membership management, function member permission management); database logical structure (cluster, database, schema, object, field, accessprivilege); database physical structure (tabl espace, datafile, segment, block, controlfile, xlog, archivelog); the following day database management (generate table space, create database, generate database template, database configuration, delete database, cross-database information access); role-based object permissions Management (tables, columns, sequences, databases, domains, external data, functions, languages, substantial objects, schemas, table spaces, sorts); default permissions and inherited permissions (defaultprivilege, inheritprivilege); database security (authentication, network, information storage , Password, injection, deception); database monitoring (status monitoring, trend monitoring, early warning, commonly made use of monitoring tools and plugins nagios, zabbix, pg_statsinfo); multi-version concurrency handle and garbage collection; every day maintenance (garbage collection, data reorganization, index upkeep) , VM maintenance, prevention of XID overflow, log maintenance); third day data migration (logical backup and restore, incremental information migration approach, heterogeneous data migration system (which include oracletopostgresql)); how to apply database patch; database version upgrade (Smaller version upgrade strategy, substantial version upgrade approach); modeling and Benchmark (the best way to create a database test model in accordance with enterprise type, the use of test tools, in accordance with Test model and hardware standard output benchmark); database log evaluation (error code introduction, log filtering and log upkeep); database audit (parameter level audit switch, customized audit (including trigger combined with HSTORE), audit data Upkeep signifies); localization (character set, collate, encoding conversion, how to avert garbled characters); database efficiency analysis (OS performance analysis report, SQL functionality evaluation report); database inspection (the way to customize inspection things, indicators, ways to analyze inspection Inspection report);
PostgreSQL database backup and recovery, data replication, load balancing and high availability logical data backup and restore on the 1st day of three days (customized backup target, backup set compression, edit TOC file, optional restore, text restore, detailed command pg_dump, pg_dumpall, pg_restore); physical information backup and restore based on time point, XID, restore point (physical backup principle, parameter configuration, fsync interface reliability test, archive script writing, backup demo, 3 restore deadline demos, WAL doesn't create scenarios Information modification strategy); logical backup design case (in scenarios with quite a few managed databases, how you can design and style centralized backup and metadata management, and application of distributed file systems); physical backup design case (in comparison with managed databases) In many scenarios, the best way to design centralized backup and metadata management); database streaming replication concept (introduction of streaming replication protocol, synchronous and asynchronous streaming replication architecture, connected parameters, working with the commands of the streaming replication protocol to explain pg_basebackup, pg_receivexlog) ; Disaster recovery style case (logshipping, streamreplication remote disaster recovery architecture, WAN network safety, information encryption, information to become thought of for disaster recovery (Compression, network stability, and so forth.); classification and application scenarios of data replication the next day (front-end replication of middleware data distribution, back-end replication primarily based on triggers, physical replication primarily based on block adjustments, logical replication based on xlog); Front-end information replication application case (pgpool-II); back-end data replication application case (londiste3, slony-I, trigger); physical replication application case (synchronous and asynchronous streamreplication, logshipping); XLOG logical replication application case (streamreplication9.four ); Examples on the application of standby inside the upgrade from the PostgreSQL version. The third day high availability resolution (introducing the two architectures of higher availability and also the advantages and disadvantages-shared storage, replication standby; certain implementation solutions of these two HA architectures; the use of streaming replication HA Matters, WAL doesn't write scenarios, function switching in asynchronous scenarios); load balancing cases (read-write separation architecture and implementation method examples (pgpool-II), read-write load balancing architecture and implementation process examples (pgpool-II, plproxy, pg- xc));
PostgreSQL server programming 3 days initial day SQL functions (parameters: simple forms, complex varieties, OUTPUT, variable parameters, default values, table parameters; return outcome set; return table; arbitrary sort parameters) function overload (same name, but Various parameter types or diverse quantity of parameters) Function stability (volatile, steady, immutable detailed explanation) function cost and execution program function PLANCACHE subsequent day approach language (installation language, language credibility, plpgsql, plpython, ...) trigger Event trigger rule method on the third day C language function aggregation function development function content material encryption module release proxy function language (scaleout for major data, plproxy)
PostgreSQL functionality optimization three days The initial day Hardware architecture (CPU, memory, disk, storage cache, storage reliability) Hardware benchmark (cpu, memory, block device) file method characteristics and optimization (ext4, xfs, zfs, btrfs, ... .) Kernel parameter optimization cache (neighborhood cache sharedbuffer, oscache; external cache memcached, redis) parameter tuning multi-version concurrency control, lock, garbage collection, HOT, ways to minimize the generation of garbage Second day modeling and tension testing, database benchmark tpc-b, custom benchmark) index (btree, hash, gin, gist, spgist index usage, compound index, exclusive index, partial index, function index, full-text search) query optimization (histogram, price factor and calibration, clarify, Information access switch, plancache, function tri-state, join optimization, geqo, CET, window function) statistics (pg_stat *, pg_statio *) status monitoring and trend report Partition) Load balancing DEBUG, TRACE, efficiency evaluation tool functionality optimization case
PostgreSQL significant information application three days initially day regional data partition off-site information partition load balancing materialized view application in huge data accelerated data loading accelerated information export plproxy architecture and usage second day londiste3 architecture and usage pg-xc architecture and Usage pgpool-II architecture and usage The third day citusdb architecture and usage greenplum architecture and usage fdwforMPP real-time large information statistics case
PostgreSQL kernel two days 1st day approach structure backend workflow (initialization workflow, key query workflow, commands, auxiliary processes) second day probe dynamic kernel tracking
Most of this component with the PostgreSQL application case n days comes from the Blog I've written.I have refined many of the PG-related particular articles written just before then demonstrated and explained inside the type of video for readers to understand.It truly is appropriate for pals that have PostgreSQL foundation.
-------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ************************************************** ************************************************** *************************
PostgreSQL performance optimization video (18 episodes): 18. Functionality optimization training-comprehensive optimization case http://www.tudou.com/programs/view/UeXudDhDaHU/17. free formatted drive recovery software -performance evaluation tool three, use of pg_statsinfo ( (Same set as DBA education) http://www.tudou.com/programs/view/5SUCgb7_hsY/16. Performance optimization training-performance analysis tool 2, pg_stat_statements http://www.tudou.com/listplay/JW66CCxpr-s/xkOD3u8kQkE .html15. Performance optimization training-performance evaluation tool 1, sarhttp: //www.tudou.com/listplay/JW66CCxpr-s/qX8HOgBZu2M.html 14. Overall performance optimization training-PostgreSQL tension test tool pgbench explains http: //www.tudou. com / listplay / JW66CCxpr-s / OUl0DLhiJwg.html13. Overall performance optimization training-how to create the database output a good execution strategy, access switches, specify table association order, genetic algorithm http://www.tudou.com/listplay/JW66CCxpr-s /dS2x85nosBw.html 12. Efficiency Optimization Training-Detailed Explanation of PostgreSQL Lock http://www.tudou.com/listplay/JW66CCxpr-s/OsRGPcGEL9M.html 11. Efficiency Optimization Training-Explanation of PostgreSQL Transaction Isolation Level http: //www.tudou. com / listplay / JW66CCxpr-s / 2sqzjiuqKFY.html ten. Efficiency optimization Training-the impact of the 3 stability states with the function on the optimizer decomposition decomposition http://www.tudou.com/programs/view/p6E3oQEsZv0/9. Overall performance optimization training-PostgreSQLtracedebug (tracking and debugging) http: // www. tudou.com/programs/view/SbglCp2T3t4/8. Efficiency optimization training-execution program cache management, binding variable interface http://www.tudou.com/programs/view/kwmilXD7JEw/7. efficiency optimization training-auto_explain plugin, An instance of magnified heappagescan brought on by index scan http://www.tudou.com/programs/view/LwMWC4ZpOhU/6. PostgreSQL overall performance optimization training-execution technique calibration technique of page program price element (pagescancost, cpucost) example explanation http: / /www.tudou.com/programs/view/yQ0SzBqx_4w/5. PostgreSQL functionality optimization training-explanation of line evaluation algorithm, explanation of price calculation examples http://www.tudou.com/programs/view/3zgOuh7kbfs/4.PostgreSQL efficiency optimization Training-explain example explanation http://www.tudou.com/programs/view/QztOh_hCFKw3.PostgreSQL efficiency optimization training-explain output structure information and facts detailed explanation http://www.tudou.com/programs/view/OZSUbOFZ0U42.PostgreSQL efficiency optimization Training-Statistics Resolution, the price aspect introduced http://www.tudou.com/programs/view/oA1v5sDFq3Q/1.PostgreSQL performance optimization coaching - teaching atmosphere to develop explain http://www.tudou.com/programs/view/AVCbdfl9rH8/
PostgreSQL9.three management video (updating): 24. video recovery software free download full version and inspection http://www.tudou.com/programs/view/muc2XSx16lQ/23.PostgreSQL monitoring four dynamic kernel tracking stap articles http: // www. tudou.com/programs/view/nNbwv33U9co/22.PostgreSQL monitoring 3PostgreSQL functionality snapshot plus the use of graphical evaluation tool pg_statsinfo http://www.tudou.com/programs/view/5SUCgb7_hsY/21.PostgreSQL monitoring 2Trend monitoring information collection And evaluation, nagios real-time monitoring deployment and custom monitoring http://www.tudou.com/programs/view/hzLFo5qGwqU/20.PostgreSQL monitoring 1 statistical method and interpretation of statistical information http://www.tudou.com/programs / view / TLi9Bohwles / 19. Introduction to locks, lock type, lock mode, lock conflict, deadlock detection. http://www.tudou.com/listplay/QHOjn39ooAI/GbMB1RCIZXk.html 18. Implementation principle and various versions of transaction isolation level Introduction to concurrency control http://www.tudou.com/listplay/QHOjn39ooAI/iB-k4ekbqWE.html17. Shareddnothing distributed usage principles and introduction http://www.tudou.com/listplay/QHOjn39ooAI/-bDZzJeFYaE.html 16. Local Usage and optimization of partition table http://www.tudou.com/listplay/QH Ojn39ooAI / tthGvcvs_PY.html 15. Table-level replication-Londiste3, information aggregation variety, a situation where several nodes are aggregated and copied to 1 node. Http://www.tudou.com/listplay/QHOjn39ooAI/EpgRVjXllMg.html 14. Table-level replication- Londiste3, information dispersal kind, replication scenario from a single node to many nodes, hash information partition.http: //www.tudou.com/listplay/QHOjn39ooAI/rjtjbYuYcsw.html13. Table-level replication-Londiste3, Cascading replication and switching of provider roles. Http://www.tudou.com/listplay/QHOjn39ooAI/4jBRN0k66fA.html 12. Table-level replication-Londiste3, one-to-many replication, DDL replication and troubleshooting http: // www .tudou.com / listplay / QHOjn39ooAI / NlmfgJwqCbs.html 11. Table-level replication-Londiste3, install and use http://www.tudou.com/listplay/QHOjn39ooAI/k1vIzHuUrSc.html ten. Table-level replication-materialized view, help local Replication, offsite replication, heterogeneous replication (e.g. oracle, mysql, mongodb, redis to postgresql replication) http://www.tudou.com/listplay/QHOjn39ooAI/aJkaz2lSM6g.html 9. Introduction to point-to-point multi-master replication (master-master ), Table level-trigger write-up http://www.tudou.com/listplay/QHOjn3 9ooAI / 1dW8TlhwG-I.html eight. Use PG stream replication to construct a master-slave environment, a detailed introduction to synchronous and asynchronous stream replication, anxiety testing, master-slave function switching. Http://www.tudou.com/listplay/QHOjn39ooAI/Ca8XPq5I7Ng. html7. Physical backup and restore, logical backup and restore. http://www.tudou.com/listplay/QHOjn39ooAI/Od0QoG3-leM.html six. Connection pool, local cache, off-site cache. http: //www.tudou .com / listplay / QHOjn39ooAI / gFoYdxzL3q4.html five. Execution plan, price calculation formula, expense issue calibration, automatic tracking of SQL execution strategy. http://www.tudou.com/listplay/QHOjn39ooAI/WyHZcxEz5N0.html 4. download video recovery , full text Search, fuzzy query, approximate query.http: //www.tudou.com/listplay/QHOjn39ooAI/X2U9f0s04h0.html3.psql usage, SQL syntax, data type, recursive SQL usage.http: //www.tudou.com/listplay /QHOjn39ooAI/hYAo6pNgxaU.html two. PostgreSQL physics, logic, approach structure, technique tables, method function introduction. Http://www.tudou.com/listplay/QHOjn39ooAI/zAAsgrbZOXs.html 1. PostgreSQL system overview and compile and set up. Http: / /www.tudou.com/listplay/QHOjn39ooAI/1V_DtL2t0Qw.html
In response to feedback from some netizens, the redesigned instruction content is as follows, from shallow to deep, appropriate for distinct groups of people today. Like PostgreSQL improvement approach, neighborhood introduction, resource introduction 2 hours PostgreSQLSQL basics 2 days PostgreSQL database management three days PostgreSQL database backup and recovery, data Replication, load balancing and higher availability 3 days PostgreSQL server programming 3 days PostgreSQL overall performance optimization three days PostgreSQL major data application 3 days PostgreSQL kernel two days PostgreSQL application case n days Individual technical level is restricted, application case training invites knowledgeable technology Employees sharing to expand the application, such as game developers, developers of massive information analysis goods, and so on.
The detailed course content material is as follows: PostgreSQL improvement method, neighborhood introduction, resource introduction 2 hours
PostgreSQLSQL foundation two days The initial day of PostgreSQL installation, architecture foundation introduction, ways to build and access the database; SQL language foundation (create tables, manipulate table information, table association queries, aggregate queries); SQL sophisticated applications (views, foreign keys, transactions , Window function, inheritance); SQL semantic structure introduction (keywords and phrases, constants, operators, particular characters, comments, operator priority); worth expression introduction (columns, positional parameters, array subscripts, field references, operations Contact, function get in touch with, aggregate expression, window function call, sort conversion, collate expression, normal quantum query, array constructor, row constructor, expression logic operation rules); function get in touch with usage introduction (positional parameter contact, naming Parameter get in touch with, mixed get in touch with); information definition (default values, constraints, technique columns, table structure and definition modification, permissions, schema, inheritance, partition, external data); data query the subsequent day (from clause, where clause, groupbyhaving clause, window clause, select clause, outcome set operation, sorting, limit, displacement, values clause, CET usage); data kind (number, currency, character, byte, time, boolean, enumeration, geometry , Net, bit, text search, UUID, XML, JSO N, array, composite variety, variety form, object variety, pseudo type); functions and operators (logic, comparison, mathematical operations, strings, byte streams, bits, pattern matching, formatting, time, enumeration, Geometry, network, full-text search, XML, JSON, sequence, situation, array, variety, aggregation, window, subquery, row and array comparison, SRF function, program data function, program management function, trigger function, event trigger Function); variety conversion; index usage; full-text retrieval usage; parallel handle; SQL efficiency optimization;
PostgreSQL database management 3 days initially day PostgreSQL supply code installation (source structure introduction, configuration introduction, custom FLAG introduction, kernel parameter optimization, installation); database server configuration (OSUSER, initial cluster, start off database cluster, close database cluster, upgrade Database software program, anti-spoofing, information encapsulation method, SSL, SSH tunnel) Introduction to database cluster procedure structure (postmaster, logger, checkpointer, writer, walwriter, autovacuumlauncher, autovacuumworker, statscollector, backend, worker); authentication and connection (client authentication system Introduction, authentication configuration, frequent authentication method usage examples, typical authentication errors troubleshooting); pgAdminIII usage introduction (installation, use, debugging functions, upkeep information); database configuration (guc.c, parameter priority, parameter which means, improvement parameters, GUC implied parameters, how you can modify the parameters and make them productive, how you can view the present parameter values, ways to view the array of parameter values); user management (making roles, role permission management, function membership management, function member permission management); database logical structure (cluster, database, schema, object, field, accessprivilege); database physical structure (tabl espace, datafile, segment, block, controlfile, xlog, archivelog); the following day database management (generate table space, create database, generate database template, database configuration, delete database, cross-database information access); role-based object permissions Management (tables, columns, sequences, databases, domains, external data, functions, languages, substantial objects, schemas, table spaces, sorts); default permissions and inherited permissions (defaultprivilege, inheritprivilege); database security (authentication, network, information storage , Password, injection, deception); database monitoring (status monitoring, trend monitoring, early warning, commonly made use of monitoring tools and plugins nagios, zabbix, pg_statsinfo); multi-version concurrency handle and garbage collection; every day maintenance (garbage collection, data reorganization, index upkeep) , VM maintenance, prevention of XID overflow, log maintenance); third day data migration (logical backup and restore, incremental information migration approach, heterogeneous data migration system (which include oracletopostgresql)); how to apply database patch; database version upgrade (Smaller version upgrade strategy, substantial version upgrade approach); modeling and Benchmark (the best way to create a database test model in accordance with enterprise type, the use of test tools, in accordance with Test model and hardware standard output benchmark); database log evaluation (error code introduction, log filtering and log upkeep); database audit (parameter level audit switch, customized audit (including trigger combined with HSTORE), audit data Upkeep signifies); localization (character set, collate, encoding conversion, how to avert garbled characters); database efficiency analysis (OS performance analysis report, SQL functionality evaluation report); database inspection (the way to customize inspection things, indicators, ways to analyze inspection Inspection report);
PostgreSQL database backup and recovery, data replication, load balancing and high availability logical data backup and restore on the 1st day of three days (customized backup target, backup set compression, edit TOC file, optional restore, text restore, detailed command pg_dump, pg_dumpall, pg_restore); physical information backup and restore based on time point, XID, restore point (physical backup principle, parameter configuration, fsync interface reliability test, archive script writing, backup demo, 3 restore deadline demos, WAL doesn't create scenarios Information modification strategy); logical backup design case (in scenarios with quite a few managed databases, how you can design and style centralized backup and metadata management, and application of distributed file systems); physical backup design case (in comparison with managed databases) In many scenarios, the best way to design centralized backup and metadata management); database streaming replication concept (introduction of streaming replication protocol, synchronous and asynchronous streaming replication architecture, connected parameters, working with the commands of the streaming replication protocol to explain pg_basebackup, pg_receivexlog) ; Disaster recovery style case (logshipping, streamreplication remote disaster recovery architecture, WAN network safety, information encryption, information to become thought of for disaster recovery (Compression, network stability, and so forth.); classification and application scenarios of data replication the next day (front-end replication of middleware data distribution, back-end replication primarily based on triggers, physical replication primarily based on block adjustments, logical replication based on xlog); Front-end information replication application case (pgpool-II); back-end data replication application case (londiste3, slony-I, trigger); physical replication application case (synchronous and asynchronous streamreplication, logshipping); XLOG logical replication application case (streamreplication9.four ); Examples on the application of standby inside the upgrade from the PostgreSQL version. The third day high availability resolution (introducing the two architectures of higher availability and also the advantages and disadvantages-shared storage, replication standby; certain implementation solutions of these two HA architectures; the use of streaming replication HA Matters, WAL doesn't write scenarios, function switching in asynchronous scenarios); load balancing cases (read-write separation architecture and implementation method examples (pgpool-II), read-write load balancing architecture and implementation process examples (pgpool-II, plproxy, pg- xc));
PostgreSQL server programming 3 days initial day SQL functions (parameters: simple forms, complex varieties, OUTPUT, variable parameters, default values, table parameters; return outcome set; return table; arbitrary sort parameters) function overload (same name, but Various parameter types or diverse quantity of parameters) Function stability (volatile, steady, immutable detailed explanation) function cost and execution program function PLANCACHE subsequent day approach language (installation language, language credibility, plpgsql, plpython, ...) trigger Event trigger rule method on the third day C language function aggregation function development function content material encryption module release proxy function language (scaleout for major data, plproxy)
PostgreSQL functionality optimization three days The initial day Hardware architecture (CPU, memory, disk, storage cache, storage reliability) Hardware benchmark (cpu, memory, block device) file method characteristics and optimization (ext4, xfs, zfs, btrfs, ... .) Kernel parameter optimization cache (neighborhood cache sharedbuffer, oscache; external cache memcached, redis) parameter tuning multi-version concurrency control, lock, garbage collection, HOT, ways to minimize the generation of garbage Second day modeling and tension testing, database benchmark tpc-b, custom benchmark) index (btree, hash, gin, gist, spgist index usage, compound index, exclusive index, partial index, function index, full-text search) query optimization (histogram, price factor and calibration, clarify, Information access switch, plancache, function tri-state, join optimization, geqo, CET, window function) statistics (pg_stat *, pg_statio *) status monitoring and trend report Partition) Load balancing DEBUG, TRACE, efficiency evaluation tool functionality optimization case
PostgreSQL significant information application three days initially day regional data partition off-site information partition load balancing materialized view application in huge data accelerated data loading accelerated information export plproxy architecture and usage second day londiste3 architecture and usage pg-xc architecture and Usage pgpool-II architecture and usage The third day citusdb architecture and usage greenplum architecture and usage fdwforMPP real-time large information statistics case
PostgreSQL kernel two days 1st day approach structure backend workflow (initialization workflow, key query workflow, commands, auxiliary processes) second day probe dynamic kernel tracking
Most of this component with the PostgreSQL application case n days comes from the Blog I've written.I have refined many of the PG-related particular articles written just before then demonstrated and explained inside the type of video for readers to understand.It truly is appropriate for pals that have PostgreSQL foundation.
-------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ************************************************** ************************************************** *************************
PostgreSQL performance optimization video (18 episodes): 18. Functionality optimization training-comprehensive optimization case http://www.tudou.com/programs/view/UeXudDhDaHU/17. free formatted drive recovery software -performance evaluation tool three, use of pg_statsinfo ( (Same set as DBA education) http://www.tudou.com/programs/view/5SUCgb7_hsY/16. Performance optimization training-performance analysis tool 2, pg_stat_statements http://www.tudou.com/listplay/JW66CCxpr-s/xkOD3u8kQkE .html15. Performance optimization training-performance evaluation tool 1, sarhttp: //www.tudou.com/listplay/JW66CCxpr-s/qX8HOgBZu2M.html 14. Overall performance optimization training-PostgreSQL tension test tool pgbench explains http: //www.tudou. com / listplay / JW66CCxpr-s / OUl0DLhiJwg.html13. Overall performance optimization training-how to create the database output a good execution strategy, access switches, specify table association order, genetic algorithm http://www.tudou.com/listplay/JW66CCxpr-s /dS2x85nosBw.html 12. Efficiency Optimization Training-Detailed Explanation of PostgreSQL Lock http://www.tudou.com/listplay/JW66CCxpr-s/OsRGPcGEL9M.html 11. Efficiency Optimization Training-Explanation of PostgreSQL Transaction Isolation Level http: //www.tudou. com / listplay / JW66CCxpr-s / 2sqzjiuqKFY.html ten. Efficiency optimization Training-the impact of the 3 stability states with the function on the optimizer decomposition decomposition http://www.tudou.com/programs/view/p6E3oQEsZv0/9. Overall performance optimization training-PostgreSQLtracedebug (tracking and debugging) http: // www. tudou.com/programs/view/SbglCp2T3t4/8. Efficiency optimization training-execution program cache management, binding variable interface http://www.tudou.com/programs/view/kwmilXD7JEw/7. efficiency optimization training-auto_explain plugin, An instance of magnified heappagescan brought on by index scan http://www.tudou.com/programs/view/LwMWC4ZpOhU/6. PostgreSQL overall performance optimization training-execution technique calibration technique of page program price element (pagescancost, cpucost) example explanation http: / /www.tudou.com/programs/view/yQ0SzBqx_4w/5. PostgreSQL functionality optimization training-explanation of line evaluation algorithm, explanation of price calculation examples http://www.tudou.com/programs/view/3zgOuh7kbfs/4.PostgreSQL efficiency optimization Training-explain example explanation http://www.tudou.com/programs/view/QztOh_hCFKw3.PostgreSQL efficiency optimization training-explain output structure information and facts detailed explanation http://www.tudou.com/programs/view/OZSUbOFZ0U42.PostgreSQL efficiency optimization Training-Statistics Resolution, the price aspect introduced http://www.tudou.com/programs/view/oA1v5sDFq3Q/1.PostgreSQL performance optimization coaching - teaching atmosphere to develop explain http://www.tudou.com/programs/view/AVCbdfl9rH8/
PostgreSQL9.three management video (updating): 24. video recovery software free download full version and inspection http://www.tudou.com/programs/view/muc2XSx16lQ/23.PostgreSQL monitoring four dynamic kernel tracking stap articles http: // www. tudou.com/programs/view/nNbwv33U9co/22.PostgreSQL monitoring 3PostgreSQL functionality snapshot plus the use of graphical evaluation tool pg_statsinfo http://www.tudou.com/programs/view/5SUCgb7_hsY/21.PostgreSQL monitoring 2Trend monitoring information collection And evaluation, nagios real-time monitoring deployment and custom monitoring http://www.tudou.com/programs/view/hzLFo5qGwqU/20.PostgreSQL monitoring 1 statistical method and interpretation of statistical information http://www.tudou.com/programs / view / TLi9Bohwles / 19. Introduction to locks, lock type, lock mode, lock conflict, deadlock detection. http://www.tudou.com/listplay/QHOjn39ooAI/GbMB1RCIZXk.html 18. Implementation principle and various versions of transaction isolation level Introduction to concurrency control http://www.tudou.com/listplay/QHOjn39ooAI/iB-k4ekbqWE.html17. Shareddnothing distributed usage principles and introduction http://www.tudou.com/listplay/QHOjn39ooAI/-bDZzJeFYaE.html 16. Local Usage and optimization of partition table http://www.tudou.com/listplay/QH Ojn39ooAI / tthGvcvs_PY.html 15. Table-level replication-Londiste3, information aggregation variety, a situation where several nodes are aggregated and copied to 1 node. Http://www.tudou.com/listplay/QHOjn39ooAI/EpgRVjXllMg.html 14. Table-level replication- Londiste3, information dispersal kind, replication scenario from a single node to many nodes, hash information partition.http: //www.tudou.com/listplay/QHOjn39ooAI/rjtjbYuYcsw.html13. Table-level replication-Londiste3, Cascading replication and switching of provider roles. Http://www.tudou.com/listplay/QHOjn39ooAI/4jBRN0k66fA.html 12. Table-level replication-Londiste3, one-to-many replication, DDL replication and troubleshooting http: // www .tudou.com / listplay / QHOjn39ooAI / NlmfgJwqCbs.html 11. Table-level replication-Londiste3, install and use http://www.tudou.com/listplay/QHOjn39ooAI/k1vIzHuUrSc.html ten. Table-level replication-materialized view, help local Replication, offsite replication, heterogeneous replication (e.g. oracle, mysql, mongodb, redis to postgresql replication) http://www.tudou.com/listplay/QHOjn39ooAI/aJkaz2lSM6g.html 9. Introduction to point-to-point multi-master replication (master-master ), Table level-trigger write-up http://www.tudou.com/listplay/QHOjn3 9ooAI / 1dW8TlhwG-I.html eight. Use PG stream replication to construct a master-slave environment, a detailed introduction to synchronous and asynchronous stream replication, anxiety testing, master-slave function switching. Http://www.tudou.com/listplay/QHOjn39ooAI/Ca8XPq5I7Ng. html7. Physical backup and restore, logical backup and restore. http://www.tudou.com/listplay/QHOjn39ooAI/Od0QoG3-leM.html six. Connection pool, local cache, off-site cache. http: //www.tudou .com / listplay / QHOjn39ooAI / gFoYdxzL3q4.html five. Execution plan, price calculation formula, expense issue calibration, automatic tracking of SQL execution strategy. http://www.tudou.com/listplay/QHOjn39ooAI/WyHZcxEz5N0.html 4. download video recovery , full text Search, fuzzy query, approximate query.http: //www.tudou.com/listplay/QHOjn39ooAI/X2U9f0s04h0.html3.psql usage, SQL syntax, data type, recursive SQL usage.http: //www.tudou.com/listplay /QHOjn39ooAI/hYAo6pNgxaU.html two. PostgreSQL physics, logic, approach structure, technique tables, method function introduction. Http://www.tudou.com/listplay/QHOjn39ooAI/zAAsgrbZOXs.html 1. PostgreSQL system overview and compile and set up. Http: / /www.tudou.com/listplay/QHOjn39ooAI/1V_DtL2t0Qw.html
 I hope to assist some good friends by way )