On Mon，2003-08-25 16:28，Gregory S. Williamson写道：
On Mon, 2003-08-25 at 16:28, Gregory S. Williamson wrote:
我们的一个系统管理员发送了这个链接...想知道是否有任何评论来自linux和数据库的实际用户世界。 < story.news.yahoo/news?tmpl = story& cid = 1738& ncid = 738& e = 9& u = / zd / 20030825 / tc_zd / 55311> One of our sysads sent this link ... wondering if there is any comment on it from the world of actual users of linux and a database. <story.news.yahoo/news?tmpl=story&cid=1738&ncid=738&e=9&u=/zd/20030825/tc_zd/55311>弱点包括缺乏可用工具，易用性和易用性 安装 听起来他需要点滴和流口水工具...... 另一方面，甚至可能是一个强大的Linux 2.4 *今天*系统处理 a 24x7 500GB数据库，每天必须处理6-8M OLTP风格的交易，同时还会受到报告查询的影响？ 不要以为这是一个巨魔，因为我真的不知道，即使我知道MVS，OpenVMS& Solaris可以。 （我甚至不想询问有关Windows和FreeBSD等玩具的问题。） - ---- -------------------------------------------------- ----------- Ron Johnson，Jr。 ro ***********@cox 美国路易斯安那州杰斐逊 知识应该是免费的所有。 Harcourt Fenton Mudd，星际迷航：TOS，我，Mudd --------------- ------------（广播结束）--------------------------- 提示2：您可以使用取消注册命令一次性取消所有列表 （发送取消注册YourEmailAddressHere到 ma ******* @ postgresql ）
"Weak points include lack of available tools, ease of use and ease of installation" Sounds like he needs point-and-drool tools... On the other hand, could even a beefy Linux 2.4 *today* system handle a 24x7 500GB db that must process 6-8M OLTP-style transactions per day, while also getting hit by report queries? Don''t think of this as a troll, because I really don''t know, even though I do know that MVS, OpenVMS & Solaris can. (I won''t even ask about toys like Windows and FreeBSD.) -- ----------------------------------------------------------------- Ron Johnson, Jr. ro***********@cox Jefferson, LA USA "Knowledge should be free for all." Harcourt Fenton Mudd, Star Trek:TOS, "I, Mudd" ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to ma*******@postgresql)
推荐答案>> >>> " RJ" == Ron Johnson< ro *********** @ cox>写道： RJ>不要以为这是一个巨魔，因为我真的不知道，甚至还不知道。虽然我知道MVS，OpenVMS& Solaris可以。 （我甚至不会对你来说是一个问题，而是询问有关像Windows和FreeBSD这样的玩具。） 好吧，如果你认为FreeBSD，你必须吸一些有趣的东西是一个 ''玩具'与窗户混在一起.... 我在FreeBSD上运行24x7x365分贝，*从不*崩溃在它已经投入生产的3年内。只有停机时间从 PG 7.1升级到7.2，一次从RAID5切换到RAID10。因为我正在使磁盘I / O饱和，所以* * * * * $ 在从新的盒子上从PG 7.2更新到 7.4后很快就会有几分钟的停机时间 旧盒子上的带宽。 eRServer软件将在现场数据库上进行数据迁移，因此我没有明显的停机时间。 数据库目前在磁盘上约为27Mb（包括索引）和 每天处理数百万次插入和更新，每两周删除几百万美元的b $ b。 - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = Vivek Khera，Ph.D。 Khera Communications，Inc。 互联网： kh***@kciLink Rockville，MD + 1- 240-453-8497 AIM：vivekkhera Y！：vivek_khera www.khera/~vivek/ --------------------- ------（广播结束）--------------------------- 提示9：如果您的 加入列的数据类型不匹配，计划者将忽略您选择索引扫描的愿望 >>>>> "RJ" == Ron Johnson <ro***********@cox> writes: RJ> Don''t think of this as a troll, because I really don''t know, even RJ> though I do know that MVS, OpenVMS & Solaris can. (I won''t even RJ> ask about toys like Windows and FreeBSD.) Well, you must be smoking something funny if you think FreeBSD is a ''toy'' to be lumped in with windows.... I run a 24x7x365 db on FreeBSD which has *never* crashed in the 3 years it has been in production. Only downtime was the upgrade from PG 7.1 to 7.2 and once for a switchover from RAID5 to RAID10. I *may* have a few minutes of down time shortly when updating from PG 7.2 to 7.4 on a new box since I''m saturating the disk I/O bandwidth on the old box. The eRServer software will be doing the data migration on the live db so I don''t have significant down time. The DB is currently about 27Mb on disk (including indexes) and processes several million inserts and updates daily, and a few million deletes once every two weeks. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: kh***@kciLink Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera www.khera/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column''s datatypes do not match
On Tue ，2003-08-26 10：00，Dennis Gearon写道： On Tue, 2003-08-26 at 10:00, Dennis Gearon wrote: 免费的BSD可能是玩具，也许不是，但它运行的网站主机比其他任何操作系统都多。 那应该是个玩笑。将FreeBSD放在同一个班级中使用Winblows的是一个初步的荒谬，无论你怎么削减它... Ron Johnson写道： Free BSD may be a toy, maybe not, but it runs more of the webhosting domains than any other OS. That was supposed to be a joke. Putting FreeBSD in the same class with Winblows is a prima facia absurdity, no matter how you cut it... Ron Johnson wrote: 在星期一，2003-08-25 16:28，Gregory S. Williamson写道： [snip]虽然我知道MVS，OpenVMS& Solaris可以。 （我甚至不会询问像Windows和FreeBSD这样的玩具。） On Mon, 2003-08-25 at 16:28, Gregory S. Williamson wrote: [snip]though I do know that MVS, OpenVMS & Solaris can. (I won''t evenask about toys like Windows and FreeBSD.)
- -------------------------------------------------- --------------- Ron Johnson，Jr。 ro *********** @ cox 美国路易斯安那州杰斐逊 百万美元中文说中文，它不是遗传的...... Dean Edell博士 ------------- --------------（广播结束）--------------------------- 提示1：订阅和取消订阅命令转到 ma*******@postgresql
-- ----------------------------------------------------------------- Ron Johnson, Jr. ro***********@cox Jefferson, LA USA "Millions of Chinese speak Chinese, and it''s not hereditary..." Dr. Dean Edell ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql
昨天看完这篇文章后，我做了一些研究。一个_big_原因 为什么Sourceforge / VA / OSDN从PostgreSQL转移到IBM / Webshere / DB2是 由此产生的产品将由Sourceforge和IBM共同销售s $ z $ b亿的销售人员。因此，他们不仅会获得一个闪亮的新数据库，而且还会获得后期收入。 这些公司将联合营销和销售该软件作为其中一部分 商业协议。 - 第4段，最后一句。 www.eweek/print_article/0...a=30025,00.asp 今日另行公告，VA Software宣布与IBM签署一项重要的商业协议，重点关注下一代SourceForgea？企业版的联合营销和销售。&bbsp; - 来自 的第7段报告 www.vasoftware/news/press.php/2002/1070.html 也许PostgreSQL团队对这项工作的投标，如果有人甚至咨询过， 并没有像IBM那样构建项目 - 产品合资企业。这是一个很好的 战术，我不会因为这个机会而责怪Sourceforge。 这个决定并不完全是技术性的，所以我不要把这看作是一个损失，因为它是b $ b $ PostgreSQL。无论如何DB2都不是一个懒散的数据库，但并不是很多公司能够像Sourceforge那样与IBM讨价还价。如果您是Topeka的零售商 有3个地点，我怀疑IBM会给予您同样的关注或联合 他们给Sourceforge的营销协议。 DB2不便宜。 - Best， Al Hulaton |高级客户工程师| Command Prompt，Inc。 503.222.2783 | ah******@commandprompt Mammoth PostgreSQL的主页和''实用的PostgreSQL'' 托管PostgreSQL，Linux服务和咨询 阅读和搜索O''Reilly的''实用PostgreSQL'' wwwmandprompt ----- ----------------------（播出结束）----------------------- ---- 提示2：您可以使用取消注册命令一次性取消所有列表 （发送取消注册YourEmailAddressHere到 ma ******* @ postgresql ） After seeing this article yesterday, I did a bit of research. One _big_ reason why Sourceforge/VA/OSDN is moving over to IBM/Webshere/DB2 from PostgreSQL is the resulting product will be jointly marketed by Sourceforge and IBM''s zillions of sales people. So not only will they get a shiny, new db, but backend revenue. "The companies will jointly market and sell the software as part of the commercial agreement. "-- 4th paragraph, last sentence. www.eweek/print_article/0...a=30025,00.asp "In a separate announcement today, VA Software announced a significant commercial agreement with IBM focused on the joint marketing and sales of the next generation of SourceForgea?￠ Enterprise Edition." -- 7th paragram from their press release at www.vasoftware/news/press.php/2002/1070.html Perhaps the PostgreSQL team bidding for the job, if any were even consulted, didn''t frame the project as IBM did -- a product joint venture. It''s a good tactic and I don''t blame Sourceforge one bit for the opportunity. The decision wasn''t entirely technical so I don''t see this as a loss for PostgreSQL. DB2 isn''t a slouch db by any means but not many companies will be able to bargain with IBM as Sourceforge did. If you''re a retailer in Topeka with 3 locations, I doubt IBM would give you the same attention or joint marketing deal they gave Sourceforge. DB2 ain''t cheap. -- Best, Al Hulaton | Sr. Account Engineer | Command Prompt, Inc. 503.222.2783 | ah******@commandprompt Home of Mammoth PostgreSQL and ''Practical PostgreSQL'' Managed PostgreSQL, Linux services and consulting Read and Search O''Reilly''s ''Practical PostgreSQL'' at wwwmandprompt ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to ma*******@postgresql)
更多推荐
Linux准备好用于大容量数据库？
发布评论