pg数据库和oracle库性能验证,Oracle与Postgresql数据库对比.ppt

? 2009 GZ PMPARK Ltd. All Rights Reserved. * ? 2009 GZ PMPARK Ltd. All Rights Reserved. * Click to edit Master title style,the title can be up to threelines long (if required) Click to edit Master subtitle style * ? 2012 GZ PMPARK Ltd. All Rights Reserved. * ? 2012 GZ PMPARK Ltd. All Rights Reserved. Click to edit Master title style,the title can be up to threelines long (if required) Click to edit Master subtitle style * ? 2012 GZ PMPARK Ltd. All Rights Reserved. * ? 2012 GZ PMPARK Ltd. All Rights Reserved. Oracle与Postgresql对比方案 Oracle 数据库产品 Aoracle 数据库产品系列 Boracle 数据库发展史 Coracle vs Postgresql 以及市场份额 Doracle 常用选件 Oracle 数据库产品系列 应用 中间件 数据库 系统与硬件 Oracle 数据库产品系列 Oracle 数据库产品系列 84 读一致性 89 并行服务器 97 表分区 闪回查询 82 跨平台 01 RAC与DG 04 自动管理 Oracle 数据库发展史 ? 2009 GZ PMPARK Ltd. All Rights Reserved. Postgresql简介 PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation. / ? 2009 GZ PMPARK Ltd. All Rights Reserved. Postgresql数据库限制 Limit Value Maximum Database Size Unlimited Maximum Table Size 32 TB Maximum Row Size 1.6 TB Maximum Field Size 1 GB Maximum Rows per Table Unlimited Maximum Columns per Table 250 - 1600 depending on column types Maximum Indexes per Table Unlimited Oracle vs Postgre