TB级 PostgreSQL 拾零

概述有关TB级以上 PostgreSQL 数据库的一些信息： Well I can’t speak to MS SQL-Server because all of our clients run PostgreSQL ;).. I can tell you we have many that are in the 500GB - 1.5TB range. All perform admirably a

有关TB级以上 Postgresql 数据库的一些信息：

Well I can’t speak to MS sql-Server because all of our clIEnts run
Postgresql ;).. I can tell you we have many that are in the 500GB -
1.5TB range.

All perform admirably as long as you have the harDWare behind it and are
doing correct table structuring (such as table partitioning).

Sincerely,

–Joshua D. Drake

We have several TB database in production and it works well on
HP rx1620 dual Itanium2,MSA 20,running linux. It’s read-only storage for
astronomical catalogs with about 4-billions objects. We have custom
index for spherical coordinates which provIDe great performance.

–oleg

I had a clIEnt that trIEd to use Ms sql Server to run a 500Gb+ database.
The database simply colapsed. They switched to teradata and it is
running good. This database has Now 1.5Tb+.

Currently I have clIEnts using postgresql huge databases and they are
happy. In one clIEnt’s database the biggest table has 237Gb+ (only 1
table!) and postgresql run the database without problem using
partitioning,triggers and rules (using postgresql 8.2.5).

–Pablo

I think either would work; both Postgresql and MS sql Server have
success storIEs out there running vldbs. It really depends on what you
kNow and what you have. If you have a lot of experIEnce with Postgres
running on linux,and not much with sql Server on windows,of course the
former would be a better choice for you. You stand a much better chance
working with tools you kNow.

–Pablo Alcaraz

All of those responses have cooked up quite a few topics into one. Large
databases might mean text warehouses,XML message stores,relational
archives and fact-based business data warehouses.

The main thing is that TB-sized databases are performance critical. So
it all depends upon your workload really as to how well Postgresql,or
another other RDBMS vendor can handle them.

Anyway,my reason for replying to this thread is that I’m planning
changes for Postgresql 8.4+ that will make allow us to get bigger and
faster databases. If anybody has specific concerns then I’d like to hear
them so I can consIDer those things in the planning stages.

–Simon Riggs

总结

以上是内存溢出为你收集整理的TB级 PostgreSQL 拾零全部内容，希望文章能够帮你解决TB级 PostgreSQL 拾零所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。