- PostgreSQL中文学习手册 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (数据表 数据表 ) 4 一、表的定义: 一、表的定义: 一、表的定义: . 4 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (模式 Schema) Schema) .9 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (表的继承和分区 表的继承和分区 表的继承和分区 表的继承和分区 ) 10 一、表的继承: 一、表的继承: 一、表的继承: .10 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (常用数据类型 常用数据类型 常用数据类型 ) 16 一、数值类型: 一、数值类型: 一、数值类型: .16 六、数组: 六、数组: .22 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (函数和操作符 函数和操作符 函数和操作符 <一>) 25 一、逻辑操作符: 一、逻辑操作符: 一、逻辑操作符: 一、逻辑操作符: .25 四、字符串函数和操作: 四、字符串函数和操作: 四、字符串函数和操作: 四、字符串函数和操作: 四、字符串函数和操作: 四、字符串函数和操作: .27 五、位串函数和操作符: 五、位串函数和操作符: 五、位串函数和操作符: 五、位串函数和操作符: 五、位串函数和操作符: .29 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (函数和操作符 函数和操作符 函数和操作符 <二>) 30 六、模式匹配: 六、模式匹配: 六、模式匹配: .30 八、时间 八、时间 /日期函数和操作符: 日期函数和操作符: 日期函数和操作符: 日期函数和操作符: 日期函数和操作符: 33 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (函数和操作符 函数和操作符 函数和操作符 <三>) 35 九、序列操作函数: 九、序列操作函数: 九、序列操作函数: 九、序列操作函数: . 35 十二、系统信息 十二、系统信息 十二、系统信息 函数: 函数: .38 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (索引 ) 42 一、索引的类型: 一、索引的类型: 一、索引的类型: 一、索引的类型: .42 四、唯一索引: 四、唯一索引: 四、唯一索引: .43 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (事物隔离 事物隔离 ) 45 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (性能提升技巧 性能提升技巧 性能提升技巧 ) 46 一、使用 一、使用 EXPLAINEXPLAINEXPLAINEXPLAIN EXPLAIN: 46 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (服务器配置 服务器配置 服务器配置 ) 50 一、服务器进程的启动和关闭: 一、服务器进程的启动和关闭: 一、服务器进程的启动和关闭: 一、服务器进程的启动和关闭: 一、服务器进程的启动和关闭: 一、服务器进程的启动和关闭: . 50 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (角色和权限 角色和权限 角色和权限 ) 52 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (数据库管理 数据库管理 数据库管理 ) 54 一、概述: 一、概述: .54 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (数据库维护 数据库维护 数据库维护 ) 56 一、恢复磁盘空间: 一、恢复磁盘空间: 一、恢复磁盘空间: 一、恢复磁盘空间: . 56 二、更新规划器统计: 二、更新规划器统计: 二、更新规划器统计: 二、更新规划器统计: 二、更新规划器统计: .57 四、定期重建索引: 四、定期重建索引: 四、定期重建索引: 四、定期重建索引: . 59 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (系统表 系统表 ) 61 一、 pg_class: pg_class: pg_class: pg_class:pg_class: 61 三、 pg_attrdef: pg_attrdef: pg_attrdef:pg_attrdef:pg_attrdef:pg_attrdef:pg_attrdef:pg_attrdef:pg_attrdef: . 63 四、 pg_authid: pg_authid: pg_authid: pg_authid:pg_authid: 64 五、 pg_auth_members: pg_auth_members: pg_auth_members: pg_auth_members:pg_auth_members: pg_auth_members:pg_auth_members:pg_auth_members:pg_auth_members: .64 七、 pg_tablespace: pg_tablespace: pg_tablespace: pg_tablespace: pg_tablespace: pg_tablespace:pg_tablespace: .65 十、 pg_index: pg_index: pg_index:pg_index:pg_index:pg_index: . 67 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (系统视图 系统视图 ) 68 一、 pg_tables: pg_tables: pg_tables: pg_tables: pg_tables: 68 二、 pg_indexes: pg_indexes: pg_indexes:pg_indexes:pg_indexes:pg_indexes: 68 三、 pg_views: pg_views:pg_views: pg_views: pg_views:pg_views: . 68 四、 pg_user: pg_user: pg_user:pg_user:pg_user: .69 五、 pg _roles:_roles:_roles:_roles: _roles: 69 六、 pg_rules: pg_rules:pg_rules:pg_rules: pg_rules: 69 七、 pg_settings: pg_settings: pg_settings: pg_settings:pg_settings: pg_settings:pg_settings:pg_settings: .70 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (客户端命令 客户端命令 客户端命令 <一>) 70 零、口令文件: 零、口令文件: 零、口令文件: .70 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (客户端命令 客户端命令 客户端命令 <二>) 75 七、 pg_dump: pg_dump: pg_dump:pg_dump:. 75 八、 pg_restore: pg_restore:pg_restore:pg_restore: pg_restore:pg_restore:pg_restore:pg_restore: 77 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (SQL (SQL语言函数 语言函数 ) . 83 一、基本概念: 一、基本概念: 一、基本概念: .83 PostgreSQL PostgreSQL PostgreSQL学习手册 学习手册 学习手册 (PL/pgSQL (PL/pgSQL(PL/pgSQL 过程语言 过程语言 ) .86 一、概述: 一、概述:5 640浏览会员免费
- 《PostgreSQL 9从零开始学》 清华大学出版社 2013-4 ISBN:97873023167325 231浏览会员免费
- 本书从PostgreSQL数据库的源代码入手,深入分析了该数据库管理系统的底层实现细节,揭示了数据库运行的基本原理。本书的主要内容包括:PostgreSQL数据库的体系结构、存储管理、索引机制、查询编译、查询执行、并发控制机制以及安全等。4 585浏览会员免费
- POSTGRESQL 9.0 性能调校PDF电子书5 246浏览会员免费
- PostgreSQL.Up.and.Running.2nd.Edition.2014.12.pdf5 155浏览会员免费
- PostgreSQL 9 Administration Cookbook PostgreSQL 9 管理手册5 175浏览会员免费
- postgresql内核分析5 290浏览会员免费
- 目录是我(mantingfangabc)手动一条一条添加的.共享给所有需要的人. postgreSQL修炼之道从小工到专家-完整高清扫描版-完整目录5 890浏览会员免费
- MySQL和PostgreSQL的各种性能比较0 1445浏览会员免费
- PostgreSQL Explain 有图 有例子 有真相 很详细0 238浏览会员免费
- 别的网友整理的,我发布到csdn上来。初级的资料,高手绕开。0 87浏览会员免费
- 《数据库系统工程师考试试题分类精解与题型练习》(第2版)根据最新的数据库系统工程师考试大纲,对历年考试试题进行了分析和总结,对考试大纲规定的内容有重点地进行了细化和深化,并提供了大量的题型练习及详细的分析、解答。考生可通过阅读本书掌握考试大纲规定的知识点,掌握考试重点和难点,熟悉考试方法、试题形式、试题的深度和广度、考试内容的分布,以及解答问题的方法和技巧。4 280浏览会员免费
- Paperback: 464 pages Publisher: Packt Publishing - ebooks Account (November 30, 2015) Language: English ISBN-10: 1783989181 ISBN-13: 978-17839891885 95浏览会员免费
- postgresql中文资料国内不多,2012年10月10日整理出来与大家分享5 126浏览会员免费
- 本附件是PG数据库9.6.0版本的中文文档,译者是武汉大学彭煜玮教授.5 483浏览会员免费
- Packt.PostgreSQL.Developer's.Guide.20155 118浏览会员免费
- Discover how to design, develop, and maintain your database application effectively with PostgreSQL About This Book Understand how to utilize the most frequently used PostgreSQL ecosystem-related tools and technologies A hands-on guide focused primarily on providing a practical approach to learning about architecture and design considerations for database architects The book covers PostgreSQL from a data architect's perspective – covering topics from installation from source to designing tables using SQL Power Architect, as well as deciding replication and failover strategies. Who This Book Is For This book is for developers and data architects who have some exposure to databases. It is assumed that you understand the basic concepts of tables and common database objects, including privileges and security. What You Will Learn Compile PostgreSQL from source and understand the PostgreSQL architecture Configure parameters and change default settings for a PostgreSQL server Leverage the logging mechanism to identify errors and suboptimal queries Use replication to scale horizontally Set up backup and recovery processes Tweak parameters to optimize queries and processes Troubleshoot connection errors Use indexes and rewrite queries to improve performance Install and use PostgreSQL extensions Learn how to leverage the command-line client (psql) In Detail PostgreSQL is an incredibly flexible and dependable open source relational database. Harnessing its power will make your applications more reliable and extensible without increasing costs. Using PostgreSQL's advanced features will save you work and increase performance, once you've discovered how to set it up. PostgreSQL for Data Architects will teach you everything you need to learn in order to get a scalable and optimized PostgreSQL server up and running. The book starts with basic concepts like installing PostgreSQL from source and covers theoretical aspects such as concurrency and transaction management. After this, you'll learn how to set up replication, use load balancing to scale horizontally, and troubleshoot errors. Finally, you will get acquainted with useful tools available in the PostgreSQL ecosystem used for analyzing PostgreSQL logs, setting up load balancing, and recovery. Table of Contents Chapter 1: Installing PostgreSQL Chapter 2: Server Architecture Chapter 3: PostgreSQL – Object Hierarchy and Roles Chapter 4: Working with Transactions Chapter 5: Data Modeling with SQL Power Architect Chapter 6: Client Tools Chapter 7: SQL Tuning Chapter 8: Server Tuning Chapter 9: Tools to Move Data in and out of PostgreSQL Chapter 10: Scaling, Replication, and Backup and Recovery Chapter 11: PostgreSQL – Troubleshooting Chapter 12: PostgreSQL – Extras4 165浏览会员免费
- PostgreSQL数据库内核分析 清晰版,完整415页5 1020浏览会员免费
- Leverage the power of PostgreSQL replication to make your databases more robust, secure, scalable, and fast About This Book Efficiently replicate PostgreSQL using high-end techniques to protect your data and run your server without interruptions Improve reliability, fault-tolerance, and accessibility by maintaining consistency between redundant resources Get grips with the latest version of PostgreSQL with this example-based guide Who This Book Is For This book is ideal for PostgreSQL administrators who want to set up and understand replication. By the end of the book, you will be able to make your databases more robust and secure by getting to grips with PostgreSQL replication. What You Will Learn Use Point-in-time Recovery to perform data recovery as well as replication Set up synchronous as well as asynchronous streaming replication Get familiarized with the transaction log, the core component of most replication setups and its purpose Improve speed and reliability with an understanding of pgpool and PgBouncer Increase your data security and geographically distribute data Make your systems more available and secure with Linux High Availability Scale out with PL/Proxy and Postgres-XC Detect, investigate, and solve replication-related problems In Detail PostgreSQL offers a comprehensive set of replication related features. Unleashing the power of PostgreSQL provides you with countless opportunities and a competitive advantage over other database systems. This book will guide you through the most important concepts of PostgreSQL replication. It contains all the information you need to design and operate replicated setups. Beginning by giving you an understanding of replication concepts, the PostgreSQL transaction log, and Point-in-time Recovery, we gradually move on to setting up asynchronous and synchronous replication. Next up, you will learn to monitor a PostgreSQL cluster setup, deal with monitoring tools, and then move on to understanding Linux High Availability. Further, we explore widely-used tools such as Slony, SkyTools, Postgres-XC, and walbouncer, and set up PL/Proxy. Finally, you'll get acquainted with the new technology of BDR, which allows bidirectional replication in PostgreSQL. Table of Contents Chapter 1: Understanding Concepts of Replication Chapter 2: Understanding the PostgreSQL Transaction Log Chapter 3: Understanding Point-in-time Recovery Chapter 4: Setting Up Asynchronous Replication Chapter 5: Setting Up Synchronous Replication Chapter 6: Monitoring Your Setup Chapter 7: Understanding Linux High Availability Chapter 8: Working with PgBouncer Chapter 9: Working with pgpool Chapter 10: Configuring Slony Chapter 11: Using SkyTools Chapter 12: Working with Postgres-XC Chapter 13: Scaling with PL/Proxy Chapter 14: Scaling with BDR Chapter 15: Working with Walbouncer5 146浏览会员免费
- PostgreSQL数据库内核分析.基于8.4.1,网上收集,供交流学习。5 167浏览会员免费
- 扫描完整版带书签5 167浏览会员免费
- Book Description Publication Date: October 20, 2010 Accelerate your PostgreSQL system Learn the right techniques to obtain optimal PostgreSQL database performance, from initial design to routine maintenance. Discover the techniques used to scale successful database installations. Avoid the common pitfalls that can slow your system down. Filled with advice about what you should be doing; how to build experimental databases to explore performance topics, and then move what you've learned into a production database environment. Covers versions 8.1 through 9.0. In Detail PostgreSQL database servers have a common set of problems they encounter as their usage gets heavier and requirements more demanding. You could spend years discovering solutions to them all, step by step as you encounter them. Or you can just look in here. All successful database applications are destined to eventually run into issues scaling up their performance. Peek into the future of your PostgreSQL database's problems today. Know the warning signs to look for, and how to avoid the most common issues before they even happen. Surprisingly, most PostgreSQL database applications evolve in the same way: Choose the right hardware. Tune the operating system and server memory use. Optimize queries against the database, with the right indexes. Monitor every layer, from hardware to queries, using some tools that are inside PostgreSQL and others that are external. Using monitoring insight, continuously rework the design and configuration. On reaching the limits of a single server, break things up; connection pooling, caching, partitioning, and replication can all help handle increasing database workloads. The path to a high performance database system isn't always easy. But it doesn't have to be mysterious with the right guide. Approach A clear, step-by-step guide to optimizing and scaling up PostgreSQL database servers. Improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples. You'll find both here. Many of the examples given will be immediately useful for monitoring and improving your PostgreSQL deployments, providing insight into hard-to-obtain information about your database. Editorial Reviews Review I found the book to be well-written (always a plus when reading technical books) and felt it covered quite a bit of depth given its ambitious scope. Overall, it was an informative and enjoyable read. --David Christensen This book is well written and very accurate, from what I can tell, a tribute both to the author and the highly competent reviewers. I doubt there is a single PostgreSQL user or developer who could not learn something useful from this book. --Andrew Dunstan From the Back Cover Who this book is written for This book is aimed at intermediate to advanced database administrators using or planning to use PostgreSQL. Portions will also interest systems administrators looking to build or monitor a PostgreSQL installation, as well as developers interested in advanced database internals that impact application design. What you will learn from this book Learn best practices culled from years of work scaling PostgreSQL installations to handle demanding applications Uncover what makes hardware good or bad for high-performance database applications Investigate making informed speed and reliability trade-offs Tweak your operating system for best database performance Benchmark your whole system from hardware to application Follow real examnples to learn how the server parameters operate and how they impact performance Monitor what happens on your server, both in and outside of the database Find the best add-on tools that extend to core PostgreSQL database Discover how to architect replicated systems using the latest features added to PostgreSQL 9.0 About the Author Gregory Smith is the principal consultant in the United States for international PostgreSQL services firm 2ndQuadrant. Based in Baltimore, MD, he's been providing database advice to clients in industries like manufacturing, finance, and web development for twenty years. Dedicated to open-source technology since early in his career, Greg turned to full-time PostgreSQL work by diving in at the source code level. He contributes regular feature patches to the core database and has written a variety of database tools. This book reflects the perspective that he's gained over the last few years as one of the most prolific sources of advice on the popular PostgreSQL community mailing lists. Product Details Paperback: 468 pages Publisher: Packt Publishing (October 20, 2010) Language: English ISBN-10: 184951030X ISBN-13: 978-18495103015 91浏览会员免费
- PostgreSQL+经验谈(德哥)-PostgreSQL2012-p725 184浏览会员免费
- POSTGRESQL修炼之道 从小工到专家 完整版POSTGRESQL修炼之道 从小工到专家 完整版POSTGRESQL修炼之道 从小工到专家 完整版5 530浏览会员免费
- PostgreSql修炼之道从小工到专家 ~高清PDF5 2187浏览会员免费
- postgresql-9.3 文档5 126浏览会员免费
- Greenplum 官方学习手册,看了还想看1 1476浏览会员免费
- 《PostgreSQL数据库内核分析》彭智勇 完整版44M4 1531浏览会员免费
- Title: PostgreSQL Developer’s Guide Author: Amjad Shahzad, Asif Fayyaz, Ibrar Ahmed Length: 201 pages Edition: 1 Language: English Publisher: Packt Publishing Publication Date: 2015-02-20 ISBN-10: 1783989025 ISBN-13: 9781783989027 Design, develop, and implement streamlined databases with PostgreSQL About This Book Design efficient, real-world database solutions and extend your knowledge of database concepts Learn how to program using native PostgreSQL procedural languages to write custom functions Explore database partitioning and learn about query optimization techniques Who This Book Is For If you are a database developer who wants to learn how to design and implement databases for application development using PostgreSQL, this is the book for you. Existing knowledge of basic database concepts and some programming experience is required In Detail PostgreSQL is an enterprise-level database that competes among proprietary database vendors, owing to its remarkable feature set and reliability without the expensive licensing overhead. This book is a comprehensive and pragmatic guide to developing databases in PostgreSQL. Beginning with a refresher of basic SQL skills, you will gradually be exposed to advanced concepts, such as learning how to program in native PostgreSQL procedural languages, implementing triggers, custom functions, and views. You will learn database optimization techniques such as query optimization and indexing while exploring extensive code examples. Lastly, you will explore foreign data wrappers, implementing extensibility, and improving maintainability. Table of Contents Chapter 1. Getting Started with PostgreSQL Chapter 2. The Procedural Language Chapter 3. Working with Indexes Chapter 4. Triggers, Rules, and Views Chapter 5. Window Functions Chapter 6. Partitioning Chapter 7. Query Optimization Chapter 8. Dealing with Large Objects Chapter 9. Communicating with PostgreSQL Using LibPQ Chapter 10. Embedded SQL in C – ECPG Chapter 11. Foreign Data Wrapper Chapter 12. Extensions4 185浏览会员免费
- 介绍了建立了一个包含INSERT, UPDATE, SELECT数据库请求的简单的业务模型, 并使用pgbench模拟业务请求, 详细的阐述PostgreSQL数据库的调优全过程。5 1675浏览会员免费
- spotlight on oracle 性能监控教程、详细讲解性能测试中如何使用spotlight进行oracle数据库的监控分析5 370浏览会员免费
- 这篇 PostgreSQL 教程提供 SQL 的基本和高级概念。此 PostgreSQL 系列教程是专为初学 者和专业人士编写提供的,需要读者有一些基本的数据库和编程基础。0 1496浏览会员免费
- 初步介绍greenplum,适合初学者,该文档浅显易懂,对greenplum进行了系统介绍5 171浏览会员免费
- 官方文档,学习资料的必备良品,官方文档,学习资料的必备良品,官方文档,学习资料的必备良品,官方文档,学习资料的必备良品。5 2382浏览会员免费
- PostGIS最早作为一种空间数据库技术研究项目,由Refractions Research Inc所开发。Refractions公司是一个GIS 和数据库咨询公司,他们在Victoria, British Columbia, Canada均有业务开展,专注于数据集成和定制化软件开发。 我们计划继续支持和发展PostGIS以便支持一系列重要的GIS功能,包括对OpenGIS的完全支持,高级拓扑构建 (coverages, surfaces, networks类型),方便用户浏览和编辑GIS数据的桌面用户界面工具以及基于web的访问工具。 PostGIS是OSGeo基金会的孵化项目。 PostGIS的目前正在不断改善,许多FOSS4G开发商以及受益于PostGIS功能 性和全面性的全世界企业的资助。5 1460浏览会员免费
- PostgreSQL 10.1手册》基于上一版本的《PostgreSQL9.6.0中文手册》 翻译。翻译工作主要由瀚高软件的韩悦悦完成,详细请参考 PostgreSQL 10.1中文手册的翻译。 如果发现中文手册中的问题请向Github源码仓库或PostgreSQL中文手册翻译小组QQ群(309292849)反馈,也可直接向Github源码仓库提交PR。5 196浏览会员免费
- PostGIS是一个对象关系型数据库系统PostgreSQL的扩展,它能吧GIS(地理信息系统)类型对象存储在数据库中。 PostGIS有基于GiST的-R树空间索引的支持以及丰富的分析和GIS对象的处理函数支持本文档为postgis官方2.2版本中文版,包含各函数的使用方法与数据库理论.1 1027浏览会员免费
- Book Description Publication Date: October 26, 2010 Written in the cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for administrators and developers to manage databases on PostgreSQL. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order. This book is for Sysadmins, Database Administrators, Architects, Developers, and anyone with an interest in planning for or running live production databases. This book is most suited to those who have some technical experience. Editorial Reviews About the Author Simon Riggs Simon Riggs is one of the few Major Developers and Committers on the PostgreSQL database project, and is also CTO of 2ndQuadrant, providing 24x7 support and services to PostgreSQL users worldwide. Simon has worked with enterprise-class database applications for more than 20 years, with prior certifications on Oracle, Teradata and DB2. Simon is responsible for much of the database recovery and replication code in PostgreSQL, and designed or wrote many of the latest performance enhancements. He uses his operational experience to contribute to many aspects of both internal design and usability. Hannu Krosing Hannu Krosing is Principal Consultant at 2ndQuadrant and a Technical Advisor at Ambient Sound Investments. As the original database architect at Skype Technologies, Hannu was responsible for designing the Skytools suite of replication and scalability technologies. Hannu has more than 12 years experience working with, and contributing to, the PostgreSQL project. Simon Riggs Simon Riggs is one of the few Major Developers and Committers on the PostgreSQL database project, and is also CTO of 2ndQuadrant, providing 24x7 support and services to PostgreSQL users worldwide. Simon has worked with enterprise-class database applications for more than 20 years, with prior certifications on Oracle, Teradata and DB2. Simon is responsible for much of the database recovery and replication code in PostgreSQL, and designed or wrote many of the latest performance enhancements. He uses his operational experience to contribute to many aspects of both internal design and usability. Hannu Krosing Hannu Krosing is Principal Consultant at 2ndQuadrant and a Technical Advisor at Ambient Sound Investments. As the original database architect at Skype Technologies, Hannu was responsible for designing the Skytools suite of replication and scalability technologies. Hannu has more than 12 years experience working with, and contributing to, the PostgreSQL project. Product Details Paperback: 360 pages Publisher: Packt Publishing (October 26, 2010) Language: English ISBN-10: 1849510288 ISBN-13: 978-18495102885 74浏览会员免费
- GreenPlum培训材料,GreenPlum培训材料.GreenPlum培训材料.4 86浏览会员免费
- Linux下PostgreSQL安装与开机启动5 1458浏览会员免费
- PostgreSQl函数部分阅读笔记 关于函数部分在PostgreSQL中的实现问题的解释 聚集函数3 443浏览会员免费
- 数据库开发商和开源开发者都是PostgreSQL的热心拥护者。任何使用程序管理大量数据的人都可以从数据库中获得大量益处。PostgreSQL是一个非常优秀的关系数据库实现,全功能,开源且免费使用。 PostgreSQL 支持大量的主流开发语言,包括C,C++,Perl,Python,Java,Tcl以及PHP。它是最接近工业标准SQL92的查询语言,并且正在实现新的功能以兼容最新的SQL标准:SQL2003。PostgreSQL也获得数个奖项,包括三次被评为Linux Journal杂志编辑选择奖最佳数据库(2000,2003和2004年度)以及2004年度Linux新媒体奖最佳数据库系统。我们也许我们有点超越自我。你也许想知道到底PostgreSQL是什么,为什么你要使用它。 本章我们将设置场景为本书的剩余部分并提供一些关于数据库的概括性背景知识、不同类型的数据库、为什么他们非常有用以及PostgreSQL在哪些地方符合这些要求5 240浏览会员免费
- 经过PostgreSQL中文社区文档翻译小组的不懈努力,PostgreSQL 11.2手册终于翻译完成正式上线了! 《PostgreSQL 11.2手册》是基于《PostgreSQL 10.1手册》翻译,并且合并了武汉大学彭煜玮老师翻译的《PostgreSQL 11.0文档》中的大量内容。其余翻译工作由翻译小组的志愿者们完成。 感谢彭老师和翻译小组的志愿者们!在这个特殊时期,祝福包括彭老师在内的所有武汉人民,武汉加油!中国加油!-------转自公众号pg中文社区5 528浏览会员免费
- Greenplum企业应用实战 PDF电子书下载 带书签目录 完整版.pdf,自带目录可以正常使用5 0浏览会员免费
- 高阶技术postgreSQL+pgpool+Ubuntu 实现分布式流复制模式全文图解 高阶技术postgreSQL+pgpool+Ubuntu 实现分布式流复制模式全文图解3 374浏览会员免费
- PostgreSQL 从入门到精通 文档版 非扫描版 欢迎大家下载0 323浏览会员免费
- Postgresql修炼之道, 从小工到专家完整版PDF,带章节目录0 599浏览会员免费
- 详细描述了DB2与GreenPlum/PostgreSQL在各方面的差异,主要用于DB2数据库向GreenPlum/PostgreSQL数据库的迁移。5 702浏览会员免费
- PostgreSQL的专业内训材料,非常有价值! 其他地方找不到的哟~~5 552浏览会员免费
- OpenERP7 0用户手册 详细介绍OpenERP结构和二次开发 实施案例5 135浏览会员免费
- PostgreSQL 是一个自由的对象-关系数据库服务器(数据库管理系统),它在灵活的 BSD-风格许可证下发行。它提供了相对其他开放源代码数据库系统(比如 MySQL 和 Firebird),自从MySQL被Oracle收购以后,PotgreSQL逐渐成为开源关系型数据库的首选。本文集整理了最新国内外21位专家对于PostgreSQL的技术分享PPT资料0 460浏览会员免费
- PostgreSQL.High.Availability.Cookbook.2nd.Edition.2017.2.pdf0 234浏览会员免费
- PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. Also it provides NoSQL capabilities, and very rich data types and extensions. All that makes PostgreSQL a very attractive solution in various kinds of software systems. The book starts with the introduction of relational databases with PostegreSQL. It then moves on to covering data definition language (DDL) with emphasis on PostgreSQL and common DDL commands supported by ANSI SQL. You will then learn the data manipulation language (DML), and advanced topics like locking and multi version concurrency control (MVCC). This will give you a very robust background to tune and troubleshoot your application. The book then covers the implementation of data models in the database such as creating tables, setting up integrity constraints, building indexes, defining views and other schema objects. Next, it will give you an overview about the NoSQL capabilities of PostgreSQL along with Hstore, XML, Json and arrays. Finally by the end of the book, you'll learn to use the JDBC driver and manipulate data objects in the Hibernate framework.5 101浏览会员免费
- power pivot and power BI3 438浏览会员免费
- PostgreSQL 9 Administration Cookbook Second Edition5 95浏览会员免费
- PostgreSQL 最佳性能优化实践授课PPT 386页,适合对PostgreSQL了解的朋友,当然你熟悉mysql或oracle也有参考价值!5 1142浏览会员免费
- PostgreSQL 9.0 High Performance.pdf,高性能,不错的书0 61浏览会员免费
- PostgreSQL 9 Administration Cookbook5 118浏览会员免费
- PostGIS的英文版基础文档,对于学习PostGIS有很大帮助,希望大家喜欢。5 100浏览会员免费
- 在SQL数据库中高效组织层次数据的查询,将原来需要嵌套查询的数据通过parent_left,parent_right的方法处理。0 355浏览会员免费