问题描述
大家好，
我是新上榜的，我不想看起来很粗鲁，所以我想要b $ b想询问是否这是好的。
我有一个我用perl编写的程序，它使用postgresSQL
数据库作为后端。该程序有效，但性能真的很糟糕。我一直在尽可能多地阅读优化性能，但
仍然不是很合理。有一次，我的程序能够以16分10秒的速度在Pentium3 650MHz，448MB RAM
测试机上处理175,000条记录。从那以后我得到了Pentium3 1GHz，512MB系统，并且我已经尝试了很多东西以获得性能提升但是现在它已经很慢了，而且我可以''似乎弄清楚我做错了什么。
在这个清单上寻求我的计划帮助是否合适？
完全披露：程序不是最初的GPL'因为它是我公司的b $ b，但它将免费发布给家庭用户和来源
代码将被制作可用（类似于其他拆分许可计划）
虽然一旦我的公司赚回钱我认为他们将完全GPL
它（我在我的老板）关于它的案例：p）。
全部谢谢！
麦迪逊凯利
---------------------------（广播结束）----------------- ----------
提示9：如果您的
加入列的数据类型为n，则规划人员将忽略您选择索引扫描的愿望匹配
Hi all,
I am new to the list and I didn''t want to seem rude at all so I
wanted to ask if this was okay first.
I have a program I have written in perl which uses a postgresSQL
database as the backend. The program works but the performance is really
bad. I have been reading as much as I can on optimizing performance but
still it isn''t very reasonable. At one point I had my program able to
process 175,000 records in 16min 10sec on a Pentium3 650MHz, 448MB RAM
test machine. Since then I got a Pentium3 1GHz, 512MB system and I have
tried a lot of things to get the performance up but now it is
substantially slower and I can''t seem to figure out what I am doing wrong.
Would it be appropriate to ask for help on my program on this list?
Full disclosure: The program won''t be initially GPL''ed because it is for
my company but it will be released for free to home users and the source
code will be made available (similar to other split-license programs)
though once my company makes it''s money back I think they will fully GPL
it (I am on my boss''s case about it :p ).
Thanks all!
Madison Kelly
---------------------------(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
推荐答案
----- BEGIN PGP SIGNATURE -----
版本：GnuPG v1.0.6（GNU / Linux）
评论：有关信息请参阅
iD8DBQFA1ujOY5Twig3Ge + YRAvAqAKC1taBrD99lD9UpU + LX1J fHfW26CQCgoaSj
bfMFOqq / anFUVDdoDBREkRY =
= kX5D
----- END PGP SIGNATURE ---- -
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQFA1ujOY5Twig3Ge+YRAvAqAKC1taBrD99lD9UpU+LX1J fHfW26CQCgoaSj
bfMFOqq/anFUVDdoDBREkRY=
=kX5D
-----END PGP SIGNATURE-----
----- BEGIN PGP SIGNATURE -----
版本：GnuPG v1.0.6（GNU / Linux）
评论：有关信息请参阅
iD8DBQFA1ujOY5Twig3Ge + YRAvAqAKC1taBrD99lD9UpU + LX1J fHfW26CQCgoaSj
bfMFOqq / anFUVDdoDBREkRY =
= kX5D
----- END PGP SIGNATURE ---- -
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQFA1ujOY5Twig3Ge+YRAvAqAKC1taBrD99lD9UpU+LX1J fHfW26CQCgoaSj
bfMFOqq/anFUVDdoDBREkRY=
=kX5D
-----END PGP SIGNATURE-----
没问题 - w如果你担心你的软件许可证。一旦你已经采取了上述基本步骤，尝试选择一个你认为太慢的特定
查询并提供：
1. PostgreSQL版本
2.基本硬件信息（如你所示）
3.表格大小。
4. EXPLAIN ANALYZE的输出<在这里查询>
EXPLAIN ANALYZE运行查询并显示PG认为它有多少工作
将是多少和多少它实际上是原来的。
HTH
-
Richard Huxton
Archonet Ltd
---------------------------（播出结束）------ ---------------------
提示6：您是否搜索了我们的列表档案？
http://archives.postgresql.org
No problem - what you licence your software under is your concern. Once
you''ve taken the basic steps described above, try to pick out a specific
query that you think is too slow and provide:
1. PostgreSQL version
2. Basic hardware info (as you have)
3. Sizes of tables.
4. Output of EXPLAIN ANALYZE <query here>
The EXPLAIN ANALYZE runs the query and shows how much work PG thought it
would be and how much it actually turned out to be.
HTH
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
这篇关于新的列表;这是一个好问题吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！