OSCON 2006：PostgreSQL严重不足

Theo Schlossnagle is a principal at OmniTI Computer Consulting, working in the areas of scalable internet architectures, database replication, and e-mail infrastructure.

Theo Schlossnagle是OmniTI Computer Consulting的负责人 ，负责可伸缩的Internet体系结构，数据库复制和电子邮件基础结构领域。

This talk was on converting a really large (over 3 terabytes, largest table is 1.8 billion rows) data warehouse database from Oracle 8i to PostgreSQL. The reason for the conversion was to save in licensing costs. They wanted to move their Oracle licenses over from the data warehouse DB to use them on the online transaction processing (OLTP) system.

这次演讲是关于将一​​个非常大的数据库仓库(超过3 TB，最大表为18亿行)从Oracle 8i转换为PostgreSQL。 进行转换的原因是节省许可成本。 他们想将Oracle许可证从数据仓库DB移出，以在在线事务处理(OLTP)系统上使用它们。

The reason for choosing Postgres over MySQL was that Postgres has a much longer history with the kind of advanced features he needed. They needed (and were able to hack PostgreSQL to get) the following features:

选择Postgres而不是MySQL的原因是Postgres拥有他所需的高级功能的悠久历史。 他们需要(并能够破解PostgreSQL来获得)以下功能：

1. Data partitioning (spreading tables over multiple drives) 2. Large selects (50-million-row return sets, over 100GB of data) 2. Incremental COMMITs for really, really long queries 3. Replication

1.数据分区(将表分布在多个驱动器上)2.大量选择(5000万行返回集，超过100GB的数据)2.真正非常长的查询的增量COMMIT 3.复制

The bottom line was that with some patience and creating thinking, they were able to migrate a really humongous database to PostgreSQL from Oracle, and ended up saving themselves $500,000 USD in licensing costs. A pretty good chunk of change.

最重要的是，他们经过一些耐心和创新的思考，能够将真正庞大的数据库从Oracle迁移到PostgreSQL，最终为自己节省了500,000美元的许可成本。 很大一部分变化。

Theo has put his slides up here.

西奥把他的幻灯片放在这里 。

翻译自: https://www.sitepoint.com/oscon-2006-big-bad-postgresql/