- PostgreSQL 常用命令和语句查询表,包括 psql 客户端工具使用、数据库和模式管理、用户和权限管理、表管理、表空间管理、索引、查询语句、DML 语句、事务控制、视图、存储过程/触发器、备份恢复等。5 1638浏览免费
- Packt.PostgreSQL.Cookbook.20150 94浏览免费
- 想知道要用于PostgreSQL部署的高可用性框架吗?,我们比较了PostgreSQL自动故障切换(PAF)与Replication Manager(repmgr)与Patroni之间的前3个框架。我们深入研究了框架的工作原理,设置要求,优缺点以及它们在备用服务器测试,主服务器测试和网络隔离测试(裂脑场景)中的执行情况,以帮助您确定最佳的框架来改善PostgreSQL驱动的应用程序的正常运行时间。0 1484浏览免费
- 顶级PostgreSQL DBA日常工作分享0 718浏览免费
- Packt.PostgreSQL.9.6.High.Performance.20170 93浏览免费
- postgresql_tutorial0 63浏览免费
- 人大金仓V8R6_KingbaseES_SQL语言参考手册.pdf0 645浏览免费
- 1、Create Index Directly 2、Change Conditions to Use Index 3、尽量避免在where子句中对字段进行运算,导致查询规划器放弃使用index 4、尽量避免在where子句中对字段类型进行强制转换,导致查询规划器放弃使用index 5、少用outer join,减少不必要的sub-query层级数【在不影响得到正确结果的前提下】 6、坚决避免select * 和 redundant columns【多余字段】 7、Index on Expressions 8、Partial Indexes 9、Decompose DDL【分解DDL】 10、Comprehensive optimization【综合优化】 11、索引的创建 12、查找需要删除的索引 13、查找重复的索引 14、查找需要维护的索引,并自定创建索引维护SQL 15、一个index size影响query plan的例子0 895浏览免费
- 介绍了postgreSQL的使用方法。0 51浏览免费
- HackingPostgreSQL 对于postgresql的内部源码分析0 37浏览免费
- Gone are the days where we had to use our own data centers to create our database infrastructure. We have seen a lot of progress in the cloud computing arena. We can now peacefully deploy our databases or applications on the cloud and avoid the cost and pain of managing the infrastructure. Likewise, most organizations have special projects in place to migrate their proprietary license databases to Open Source databases like PostgreSQL. Most such organizations consider it the right time to migrate to a PostgreSQL database deployed on the cloud, because doing so can save them money and effort. Thus, we knew it was time to write a book that helps users understand the advantages and limitations of all the existing cloud vendors available for deploying PostgreSQL on their platforms. This book contains the details about the major vendors available to deploy a PostgreSQL database on the cloud. It starts with an introduction to DBaaS and IaaS and a brief description of the criteria considered by organizations when deploying databases as a service. We talk about the major concerns and issues you might come across while deploying databases on the cloud. We included steps and procedures involved in migrating from on-premise to the cloud. As this book is mainly written to address the process of deploying a PostgreSQL database on the cloud, we include a detailed architecture of PostgreSQL in one of the chapters. The architecture of PostgreSQL should help you understand most of the parameters that are needed to better tune your PostgreSQL environment.0 91浏览免费
- ELK零基础到精通学习手册0 102浏览免费
- PostgreSQL 11-16版本主要特性.pdf0 173浏览免费
- The purpose of this book is to teach you the fundamental practices and techniques of database developers for programming database applications with PostgreSQL. It is targeted to database developers using PostgreSQL who have basic experience developing database applications with the system, but want a deeper understanding of how to implement programmatic functions with PostgreSQL.0 76浏览免费
- PostgreSQL IN vs EXISTS vs ANYALL vs JOIN性能分析0 291浏览免费
- PostgreSQL & Oracle-备份技术大比拼 PostgreSQL & Oracle-备份技术大比拼 PostgreSQL & Oracle-备份技术大比拼0 145浏览免费
- PostgreSQL 行可见性验证 PostgreSQL 行可见性验证 PostgreSQL 行可见性验证0 183浏览免费
- postgresql-9.4官方文档英文版,对那些需要学习pg的朋友有帮助,包括安装配置,函数与存储过程,功能扩展0 87浏览免费
- postgresql-9.0-A4.pdf postgresql doc4 104浏览免费
- POSTGRESQL中文学习手册0 118浏览免费
- .PostGreSQL安装部署系列:Centos 7.9 安装指定PostGreSQL-15版本数据库0 69浏览免费
- PostgreSQL并行管理 PostgreSQL并行管理 PostgreSQL并行管理0 190浏览免费
- Performance_Guide_CN_v1.0-1.pdf 中文文档 Performance_Guide_CN_v1.0-1.pdf 中文文档0 98浏览免费
- PPT方案转的pdf, 这是2011年的方案文档, 已过保密期. 五六十页, 可以作为方案参考.0 66浏览免费
- This PostgreSQL® Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA, see credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified This is an unofficial free book created for educational purposes and is not affiliated with official PostgreSQL® group(s) or company(s) nor Stack Overflow. All trademarks and registered trademarks are the property of their respective company owners0 64浏览免费
- 介绍postgreSQL数据库的集群,感觉解决方案还不错。做别的数据库集群也可以参考一下。0 37浏览免费
- 简明介绍 PostgreSQL 的功能和应用场景; 对于初学者选型作为参考.0 113浏览免费
- XML数据索引理论,对XML文档建立XR-tree,实现高效的结构查询。内容怎么建立XR-Tree和如何结构连接算法。是数据库索引较为经典的一篇论文。0 52浏览免费
- PostgreSQL_8.4安装操作手册 安装数据库和空间数据导入数据库0 131浏览免费
- PostgreSQL 并行管理实践手册0 75浏览免费
- Postgres_Plus_Advanced_Server_JDBC_Connector_Guide_CN_v1.1[1]0 102浏览免费
- PostgreSQL 是一种对象-关系型数据库管理系统(ORDBMS),也是目前功能最强大、特性最丰富和最复杂的自由软件数据库系统.它起源于伯克利(BSD)的数据库研究计划,目前是最重要的开源数据库产品开发项目之一, 有着非常广泛的用户.PostgreSQL 是唯一支持事务、子查询、多版本并行控制系统、数据完整性检查等特性的唯一的一种自由软件的数据库管理系统.能在多平台下---包括Linu...0 42浏览免费
- PostgreSQL-Up-and-Running-A-Practical-Guide-to-the-Advanced-Open-Source-Database,数据库课本 如题所示 全本pdf版本0 66浏览免费
- 附件来自:http://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_10_New_Features_en_20170522-1.pdf0 56浏览免费
- PostgreSQL Autovacuum内部结构与调优0 218浏览免费
- PostgreSQL 12 说明书0 79浏览免费
- 微机原理及接口技术课后答案,各章节的详解,有助于我们更好的学习这门课程0 67浏览免费
- PostgreSQL 行可见性验证实践手册0 69浏览免费
- 数据库系统概念中文版第五版,可以和外国教材配套使用0 46浏览免费
- Greenplum Database4.2 Administrator guide0 53浏览免费
- PostgreSQL Tutorial v7.3.2 官方文档,对于想学习postgreSQL的同学有帮助。这款数据库是开源的数据库中最为稳定功能强大。0 39浏览免费
- 事务的历史与SSI——PostgreSQL数据库技术峰会成都站分享。全篇分享分为4个部分:事务的基础、事务的历史、SSI理论知识、PostgresSQL中的SSI。分享内容的主要思路是从事务的历史推进到一些92标准中不存在的异象,再到消灭这些异象可以怎么做,再到pg库中的SSI是怎么做的。0 51浏览免费
- PGConf.CN2019大会资料 培训PPT--John--PostgresConf.CN - John0 88浏览免费
- postgresql-9.6 英文说明文档,官方下载,内容具体详细0 70浏览免费
- 一款摄像头的驱动芯片数据手册,希望对大家有帮助。0 65浏览免费
- 分布式数据库 Green Plum。 企业实战。你值得拥有!!!!!!!!!!!!!0 0浏览免费
- PGConf.CN2019大会资料 培训PPT--Muhammad Usama--pgconf china talk0 108浏览免费
- galy pg全球开发者大会、0 52浏览免费
- PGConf.CN2019大会资料 培训PPT--3-朱贤文--PGConf20190 66浏览免费
- 最好用的PG备份工具PG_PROBACKUP 本地+异地备份恢复部署文档0 65浏览免费
- Greenplum Database is a massively parallel processing (MPP) database server based on PostgreSQL open-source technology. MPP (also known as a shared nothing architecture) refers to systems with two or more processors that cooperate to carry out an operation - each processor with its own memory, operating system and disks. Greenplum uses this high-performance system architecture to distribute the load of multi-terabyte data warehouses, and can use all of a system’s resources in parallel to process a query. Greenplum Database is essentially several PostgreSQL database instances acting together as one cohesive database management system (DBMS). It is based on PostgreSQL 8.2.15, and in most cases is very similar to PostgreSQL with regard to SQL support, features, configuration options, and end-user functionality. Database users interact with Greenplum Database as they would a regular PostgreSQL DBMS.0 73浏览免费
- 重力资料深层次处理在研究相山矿田基底特征中的应用0 56浏览免费
- PPAS_PGP_HA_Community.pdf,postgresql的ha方案,喜欢可以下载0 58浏览免费
- Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter. Examples in the book are worked in PostgreSQL and SQLite, but the bulk of the examples are platform agnostic and will work on any database platform supporting SQL. Early in the book you learn about table design, the importance of keys as row identifiers, and essential query operations. You then move into more advanced topics such as grouping and summarizing, creating calculated fields, joining data from multiple tables when it makes business sense to do so, and more. Throughout the book, you are exposed to a set-based approach to the language and are provided a good grounding in subtle but important topics such as the effects of null value on query results. With the explosion of data science, SQL has regained its prominence as a top skill to have for technologists and decision makers worldwide. SQL Primer will guide you from the very basics of SQL through to the mainstream features you need to have a solid, working knowledge of this important, data-oriented language.0 87浏览免费
- postgresql的简单原理介绍0 116浏览免费
- PGConf.CN2019大会资料 培训PPT--5-Michael----PostgresConfCN.pdf0 67浏览免费
- PGConf.CN2019大会资料 培训PPT--9-张文升--pgconf_20190 62浏览免费
- PGConf.CN2019大会资料 培训PPT--Ibrar--PostgreSQL Conf Beijing 2019 - Deep Dive to PostgreSQL Indexes0 111浏览免费
- postgresql探秘0 82浏览免费
- GreenPlum官方安装文档,Linux 红帽子5.5 操作系统0 41浏览免费