使用PostgreSQL的应用程序类型 [英] Type of application that use PostgreSQL

问题描述

您好，


我正在定义我们的产品是否可以使用PostgreSQL。


您知道什么类型的应用程序使用PostgreSQL，以及这些项目的数据库大小是多少？


我们的应用程序有一个超过300000行的表。有许多连接有复杂的

查询。我们必须尊重一些时间限制。另外

应用程序每天24小时运行，因此产品必须稳定，

如果出现问题可以很好地恢复。


谢谢，

Jean-Marc


__________________________________________________ _______________

新的MSN 8：智能垃圾邮件保护和2个月免费*
http://join.msn.com/？ page = features / junkmail

---------------------------（播出结束） - --------------------------

提示3：如果通过Usenet发布/阅读，请发送适当的

subscribe-nomail命令 ma*******@postgresql.org ，以便你的

消息可以干净地通过邮件列表

Hello,

I am in the process to define if our product can use PostgreSQL.

Do you know what type of application use PostgreSQL, and also what is the
size of the database for these projects?

Our application has a table with more than 300000 rows. There are complexe
query with many joins. And we must respect some time constraints. Also the
application is running 24 hours per day, so the product must be stable, with
good recovery in case of problems.

Thank you,
Jean-Marc

__________________________________________________ _______________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

推荐答案

2003年10月2日星期四09： 10，我的网上写道：

On Thursday 02 October 2003 09:10, My Internet wrote:

你好，

你知道什么类型的应用程序使用PostgreSQL，以及这些项目的数据库大小是多少？


一切都来自小型企业应用程序（我用它），基于网络的应用程序，

大规模科学数据处理，GIS支持，实质性

DNS系统的一部分...

我们的应用程序有一个超过300000行的表。有许多连接有复杂的查询。我们必须尊重一些时间限制。此外，
应用程序每天24小时运行，因此产品必须稳定，并在出现问题时恢复良好。

Hello,

I am in the process to define if our product can use PostgreSQL.

Do you know what type of application use PostgreSQL, and also what is the
size of the database for these projects?
Everything from small-business apps (which I use it for), web-based apps,
large-scale scientific data processing, GIS support, substantial parts of the
DNS system...
Our application has a table with more than 300000 rows. There are complexe
query with many joins. And we must respect some time constraints. Also the
application is running 24 hours per day, so the product must be stable,
with good recovery in case of problems.

人一直在说，当处理100GB +数据库的时候在版本之间进行升级是不方便的，所以如果300万行是你最大的表，那么可能会把事情放在一边。


查询规划器通常可以很好地优化。你可能想要注意的三件事情：

- PG对类型非常严格 - 如果你有一个int2字段而不是int4

值，你会想要转换int4以确保使用索引。

- 使用JOIN关键字按照你指定的顺序强制连接 - 我

相信这是可配置的7.4

- 使用带有许多值的IN（...）可能很慢。建议的程序是使用EXISTS重写
，虽然我再次相信情况有很大改善

in 7.4

- count（*）isn'没有优化 - 它必须扫描表格。

- 您需要调整配置文件中的值，它们设置为

开始时非常小。


稳定性很好。如果你感到谨慎，你可以使用7.3.4，而不是

即将到来的7.4。它有热备份（即无需停止数据库以获得有效快照的
）。它有一个预写日志，用于在发生崩溃时重放活动的

交易，以及一些复制选项。


一些高点我想说的是：

- 良好的程序语言支持

- 许多客户端接口（C，C ++，Perl，Python，PHP，JDBC，ODBC ...）

- 符合SQL标准

- 非常有用的邮件列表


简而言之，我建议你花几天时间安装和运行一些

测试 - 开源的美妙之处在于你无需花费任何费用。

-

Richard Huxton

Archonet Ltd


--------------------------- （播出结束）---------------------------

提示3：如果通过Usenet发布/阅读，请发送适当的

subscribe-nomail命令到 ma*******@postgresql.org 这样你的

消息就可以干净地进入邮件列表

People have been saying it''s inconvenient to upgrade between versions when
dealing with 100GB+ databases, so if 3million rows is your largest table,
that might put things in perspective.

The query planner generally makes a good job optimising. Three things you
probably want to be aware of though:
- PG is very strict on types - if you have an int2 field compared to an int4
value, you will want to cast the int4 to make sure an index is used.
- Use of the JOIN keyword forces joins in the order you specify them - I
believe this is configurable in 7.4
- Use of IN (...) with many values can be slow. Recommended procedure is to
rewrite using EXISTS, although again I believe the situation is much improved
in 7.4
- count(*) isn''t optimised - it has to scan the table.
- you will need to tune the values in the configuration file, they are set
quite small to start with.

Stability is good. If you''re feeling cautious, you could use 7.3.4 rather than
the forthcoming 7.4. It''s had hot-backup (i.e. no need to stop the db to get
a valid snapshot) for ages. It has a write-ahead-log to replay active
transactions in case of a crash, and a couple of replication options.

Some of its high points I would say are:
- good proedural language support
- many client interfaces (C,C++,Perl,Python,PHP,JDBC,ODBC...)
- good compliance with SQL standards
- very helpful mailing lists

In short, I''d recommend spending a couple of days installing and running some
tests - the beauty of open-source is that it costs you nothing to try it out.
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

引用Richard Huxton< de*@archonet.com>：

Quoting Richard Huxton <de*@archonet.com>:

[stuff deleted]
稳定性好。如果你感到谨慎，你可以使用7.3.4而不是即将到来的7.4。它有热备份（即无需停止数据库以获得有效的快照）多年。它有一个预写日志，用于在发生崩溃时重放活动的事务，以及一些复制选项。
[东西删除]
-
Richard Huxton
Archonet有限公司

---------------- -----------（广播结束）---------------------------
提示3：如果通过Usenet发布/阅读，请发送适当的
subscribe-nomail命令到 ma ******* @ postgresql.org ，以便您的消息可以干净地通过邮件列表

[stuff deleted] Stability is good. If you''re feeling cautious, you could use 7.3.4 rather
than
the forthcoming 7.4. It''s had hot-backup (i.e. no need to stop the db to get

a valid snapshot) for ages. It has a write-ahead-log to replay active
transactions in case of a crash, and a couple of replication options. [stuff deleted] --
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

是否能够执行热备份功能。从7.4.x中删除？我还没看过所有

的beta3文档。

-

Keith C. Perry

网络总监&申请

VCSN，Inc。
http://vcsn.com


____________________________________

此电子邮件帐户由以下人员主持：

VCSN，Inc： http://vcsn.com


---------- -----------------（广播结束）---------------------------

提示8：解释分析是你的朋友

Is the ability to do "hot-backups" removed from 7.4.x? I haven''t read the all
of the beta3 docs yet.
--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

2003年10月2日星期四14:55:04 -0400，

网络管理员< ne ****** @ vcsn.com>写道：

On Thu, Oct 02, 2003 at 14:55:04 -0400,
Network Administrator <ne******@vcsn.com> wrote:

是否能够进行热备份？从7.4.x中删除？我还没看过所有的beta3文档。

Is the ability to do "hot-backups" removed from 7.4.x? I haven''t read the all
of the beta3 docs yet.

编号pg_dump仍然会给你一个一致的转储。


---------------------------（播出结束）------------ ---------------

提示5：您查看了我们广泛的常见问题解答吗？

http://www.postgresql.org/docs/faqs/FAQ.html

No. pg_dump still gives you a consistant dump.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

这篇关于使用PostgreSQL的应用程序类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！