- PostGIS的英文版基础文档,对于学习PostGIS有很大帮助,希望大家喜欢。5 107浏览会员免费
- Postgres-XL是一个基于PostgreSQL数据库的横向扩展开源SQL数据库集群,具有足够的灵活性来处理不同的数据库工作负载。3 193浏览会员免费
- 在SQL数据库中高效组织层次数据的查询,将原来需要嵌套查询的数据通过parent_left,parent_right的方法处理。0 367浏览会员免费
- PostgreSQL数据库在Windows和Linux环境下的安装0 414浏览会员免费
- Greenplum 官方学习手册,看了还想看1 1481浏览会员免费
- PostgreSQL9.4手册 英文版本的 希望对你有帮助 我也找不到中文版本的0 93浏览会员免费
- postgresql-9.4-A4.PDF0 76浏览会员免费
- PostgreSQL是以加州大学伯克利分校计算机系开发的 POSTGRES,现在已经更名为PostgreSQL,版本 4.2为基础的对象关系型数据库管理系统(ORDBMS)。0 387浏览会员免费
- PostGIS 2.1.8 Manual0 111浏览会员免费
- 服务端编程环境设置 第一个PL/pgSQL函数 返回结构数据 PL/pgSQL触发器 事件触发 调试PL/pgSQL 用PL/Python 用C编写高级函数0 107浏览会员免费
- PostgreSQL9.3.1 官方文档(中文版)0 175浏览会员免费
- 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 150浏览会员免费
- 主要内容包括:PostgreSQL数据库的体系结构、存储管理、索引机制、查询编译、查询执行、并发控制机制以及安全等。0 17浏览会员免费
- 数据库开发商和开源开发者都是PostgreSQL的热心拥护者。任何使用程序管理大量数据的人都可以从数据库中获得大量益处。PostgreSQL是一个非常优秀的关系数据库实现,全功能,开源且免费使用。 PostgreSQL 支持大量的主流开发语言,包括C,C++,Perl,Python,Java,Tcl以及PHP。它是最接近工业标准SQL92的查询语言,并且正在实现新的功能以兼容最新的SQL标准:SQL2003。PostgreSQL也获得数个奖项,包括三次被评为Linux Journal杂志编辑选择奖最佳数据库(2000,2003和2004年度)以及2004年度Linux新媒体奖最佳数据库系统。我们也许我们有点超越自我。你也许想知道到底PostgreSQL是什么,为什么你要使用它。 本章我们将设置场景为本书的剩余部分并提供一些关于数据库的概括性背景知识、不同类型的数据库、为什么他们非常有用以及PostgreSQL在哪些地方符合这些要求5 252浏览会员免费
- PostgreSQL9.3.1 官方参考手册,中文翻译版。花了很长时间对文档结构进行了整理,加了目录及书签,方便大家阅读4 144浏览会员免费
- PostgreSQL 是一个自由的对象-关系数据库服务器(数据库管理系统),它在灵活的 BSD-风格许可证下发行。它提供了相对其他开放源代码数据库系统(比如 MySQL 和 Firebird),自从MySQL被Oracle收购以后,PotgreSQL逐渐成为开源关系型数据库的首选。本文集整理了最新国内外21位专家对于PostgreSQL的技术分享PPT资料0 469浏览会员免费
- 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 170浏览会员免费
- 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.4 69浏览会员免费
- postgresql9.4 帮助,希望能够帮助大家5 123浏览会员免费
- postgis空间数据库权威教程 最完整的空间数据库手册5 201浏览会员免费
- 《PostgreSQL数据库内核分析》彭智勇 完整版44M4 1543浏览会员免费
- Greenplum_安装指南-0 149浏览会员免费
- 全书共18章,分别介绍了PostgreSQL9的安装与配置、数据库的基本操作、数据表的基本操作、SQL语言基础、轻松掌握SQL语句、认识函数、PostgreSQL数据查询、数据的更新、创建和使用索引、事务和锁、视图操作、触发器、PostgreSQL的安全机制、数据库的备份与恢复、高可用、负载均衡、数据复制、服务器配置、数据库监控以及数据库的内部结构等内容。4 189浏览会员免费
- 指导greenplum安装与部署以及性能优化与管理。0 145浏览会员免费
- postgresql up and running pdf0 163浏览会员免费
- PostgreSQL 性能优化培训 3 DAY3 210浏览会员免费
- PostgreSQL 9.4 adds a new unstructured data type, JSONB, a variant of JSON optimized for storing objects. JSONB complements the existing XML and JSON document objects, as well as HSTORE. Which one is right for you? We'll take a tour of the features of each, and their advantages and disadvantages for various use cases, all illustrated with real-world examples.0 130浏览会员免费
- Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.2, 9.3, and 9.4, you'll also discover that PostgeSQL is more than a database system - it's also an impressive application platform. With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. If you're a current PostgreSQL user, you'll pick up gems you may have missed before.5 79浏览会员免费
- 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 188浏览会员免费
- PostgreSQL 9 Admin Cookbook0 85浏览会员免费
- Packt.PostgreSQL.Developer's.Guide.20155 120浏览会员免费
- PostgreSQL.Up.and.Running.2nd.Edition.2014.12.pdf5 158浏览会员免费
- 适合学习和工作者的参考用书。 语言类型英文。 入门级别教程。PostgreSQL 是一个免费的对象-关系数据库服务器(ORDBMS),在灵活的BSD许可证下发行。 PostgreSQL 开发者把它念作 post-gress-Q-L。 PostgreSQL 的 Slogan 是 "世界上最先进的开源关系型数据库"0 179浏览会员免费
- 高阶技术postgreSQL+pgpool+Ubuntu 实现分布式流复制模式全文图解 高阶技术postgreSQL+pgpool+Ubuntu 实现分布式流复制模式全文图解3 381浏览会员免费
- 网上搜索了相关的文章,有的不是全对,下面的内容是本人结合两篇文章做实验后成功的,为方便以后查询,公开此教程。希望对大家有帮助,如有不对之处,还请谅解0 173浏览会员免费
- Comprehensive Manual: A4 PDF (6.8 MB)0 77浏览会员免费
- PostgreSQL 8.4官方开发文档A¥0 98浏览会员免费
- 欢迎阅读 pgpool-II 入门教程。从本教程中,你将学会如何安装,设置pgpool-II 以及使用 pgpool-II 运行并行查询和复制。我们假设你已经知道PostgreSQL的基础操作,所以如果有必要,请先参考 PostgreSQL的文档。5 197浏览会员免费
- POSTGRESQL 9.0 性能调校PDF电子书5 250浏览会员免费
- postgresqlAPI、postgresql 中文学习文档 、postgresql 使用说明、postgresql 帮助说明0 152浏览会员免费
- 介绍了建立了一个包含INSERT, UPDATE, SELECT数据库请求的简单的业务模型, 并使用pgbench模拟业务请求, 详细的阐述PostgreSQL数据库的调优全过程。5 1695浏览会员免费
- Msf下连接数据库及安装postgresql图形化管理工具5 847浏览会员免费
- MetaSploit终端下PostgreSQL数据库的使用5 226浏览会员免费
- 《PostgreSQL 9从零开始学》 清华大学出版社 2013-4 ISBN:97873023167325 244浏览会员免费
- PostgreSQL_8.1_中文(2)I教程5 206浏览会员免费
- Oracle与Postgres之间的不同。很好很详细。从Oracle转Postgres的时候非常需要的一个文档。 If you are starting to use PostgreSQL or you will migrate from Oracle database server, I hope this document helps. If you have Java applications and use JDBC, the “Data types and JDBC” section will be particularly useful. Oracle and PostgreSQL both conform to standard SQL. However, they contain several extensions and implementation details that differentiate one from the other. The most important differences are listed in this document.0 246浏览会员免费
- PostgreSQL 8.2.3 中文文档,最近刚得到手,和大家分享一下0 603浏览会员免费
- PostgreSQL 9.0 High Performance.pdf,高性能,不错的书0 65浏览会员免费
- postgresql-9.3 文档5 131浏览会员免费
- 2.0版pgRouting的用户手册。 pgRouting是PostGIS其中一个扩展模块,实现了dijkstra,astar,shootingstar,tsp等经典寻径算法。 网上大部分中文或英文的材料针对的都是pgRouting v1.3(适用postgreSQL 8.4). 9.0以后版本自带PostGIS 2.0.0,这份文档才是正解,旧函数都弃用了。4 661浏览会员免费
- 《数据库系统工程师考试试题分类精解与题型练习》(第2版)根据最新的数据库系统工程师考试大纲,对历年考试试题进行了分析和总结,对考试大纲规定的内容有重点地进行了细化和深化,并提供了大量的题型练习及详细的分析、解答。考生可通过阅读本书掌握考试大纲规定的知识点,掌握考试重点和难点,熟悉考试方法、试题形式、试题的深度和广度、考试内容的分布,以及解答问题的方法和技巧。4 285浏览会员免费
- PostgreSQL与Python。网上收集,供学习交流。0 1364浏览会员免费
- PostgreSQL+经验谈(德哥)-PostgreSQL2012-p725 187浏览会员免费
- PostgreSQL数据库内核分析.基于8.4.1,网上收集,供交流学习。5 171浏览会员免费
- greenplum学习笔记4 951浏览会员免费
- postgresql-9.0,英文版,英语好的可以看看0 122浏览会员免费
- ostgresql_必备参考手册,中文版0 50浏览会员免费
- 一个文档。mysql to pg的数据迁移的文档0 90浏览会员免费
- A Visual Guide for Migrating to Postgres Plus from MySQL0 105浏览会员免费
- Pgconfde-2011-mysql-to-pg-print 转换的一篇文章0 96浏览会员免费