新的列表;这是一个好问题吗？ [英] New to the list; would this be an okay question?
问题描述
大家好，
我是新上榜的，我不想看起来很粗鲁，所以我想要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
推荐答案
标准问题：
- 您是否已经过VACUUMed？
- 你有VACUUM ANALYZEd吗？
- 你是否对复杂的查询进行了解析分析？
- 你有没有把INDEX放在适当的列上。
您需要提供更多详细信息，如果您想要更详细的答案。
2004年6月21日星期一上午09:38:14 -0400，Madison Kelly写道：
Standard questions:
- Have you VACUUMed?
- Have you VACUUM ANALYZEd?
- Have you done EXPLAIN ANALYZE on the complex queries?
- Have you put INDEXes on the appropriate columns.
You need to give more details is you want more detailed answers.
On Mon, Jun 21, 2004 at 09:38:14AM -0400, Madison Kelly wrote:
大家好，
我是新来的，我不想看起来很粗鲁，所以我想问这是不是好的，首先。
我有一个用perl编写的程序，它使用postgresSQL
数据库作为后端。该计划有效，但表现真的很糟糕。我一直在尽力阅读优化性能，但仍然不是很合理。有一次，我的程序能够在Pentium3 650MHz，448MB RAM
测试机上以16分10秒的速度处理175,000条记录。从那以后我得到了Pentium3 1GHz，512MB系统，我已经尝试了很多东西来提高性能，但是现在它已经慢了很多，我似乎无法弄明白我是什么做错了。
在这份名单上寻求我的计划帮助是否合适？
完全披露：该程序最初不是GPL'因为它适用于我的公司，但它将免费发布给家庭用户并且源代码将被制作可用（类似于其他拆分许可计划）
虽然一旦我的公司将其退还给我的钱，我认为他们将完全支持GPL（我在老板的案例中是关于它的：p谢谢大家！
麦迪逊凯利
------------------- --------（广播结束）---------------------------
提示9：策划人将如果您的
加入列的数据类型与
不匹配，则忽略您选择索引扫描的愿望
-
Martijn van Oosterhout< kl*****@svana.org> http://svana.org/kleptog/ 专利。 ñ。天才是5％的灵感和95％的汗水。专利是一种工具，用于完成5％的工作，然后坐在那里等待某人其他95％，这样你就可以起诉他们。
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
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
----- BEGIN PGP SIGNATURE -----
版本：GnuPG v1.0.6（GNU / Linux）
评论：有关信息请参阅 http://www.gnupg.org
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-----
标准问题：
- 您是否已经过VACUUMed？
- 你有VACUUM ANALYZEd吗？
- 您是否对复杂的查询进行了解析分析？
- 您是否将INDEX放在适当的列上。
你需要提供更多详细信息，你需要更详细的答案。
2004年6月21日星期一上午09:38:14 -0400，Madison Kelly写道：
Standard questions:
- Have you VACUUMed?
- Have you VACUUM ANALYZEd?
- Have you done EXPLAIN ANALYZE on the complex queries?
- Have you put INDEXes on the appropriate columns.
You need to give more details is you want more detailed answers.
On Mon, Jun 21, 2004 at 09:38:14AM -0400, Madison Kelly wrote:
大家好，
我是新手，我不想看起来很粗鲁，所以我想先问一下这是否合适。
我有一个用perl编写的程序，它使用postgresSQL
数据库作为后端。该计划有效，但表现真的很糟糕。我一直在尽力阅读优化性能，但仍然不是很合理。有一次，我的程序能够在Pentium3 650MHz，448MB RAM
测试机上以16分10秒的速度处理175,000条记录。从那以后我得到了Pentium3 1GHz，512MB系统，我已经尝试了很多东西来提高性能，但是现在它已经慢了很多，我似乎无法弄明白我是什么做错了。
在这份名单上寻求我的计划帮助是否合适？
完全披露：该程序最初不是GPL'因为它适用于我的公司，但它将免费发布给家庭用户并且源代码将被制作可用（类似于其他拆分许可计划）
虽然一旦我的公司将其退还给我的钱，我认为他们将完全支持GPL（我在老板的案例中是关于它的：p谢谢大家！
麦迪逊凯利
------------------- --------（广播结束）---------------------------
提示9：策划人将如果您的
加入列的数据类型与
不匹配，则忽略您选择索引扫描的愿望
-
Martijn van Oosterhout< kl*****@svana.org> http://svana.org/kleptog/ 专利。 ñ。天才是5％的灵感和95％的汗水。专利是一种工具，用于完成5％的工作，然后坐在那里等待某人其他95％，这样你就可以起诉他们。
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
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
----- BEGIN PGP SIGNATURE -----
版本：GnuPG v1.0.6（GNU / Linux）
评论：有关信息请参阅 http://www.gnupg.org
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-----
Madison Kelly写道：
Madison Kelly wrote:
大家好，
我是新来的，我根本不想显得粗鲁，所以我想先问问这是否合适。
没问题。阅读下面的消息，您可能想要尝试
性能列表，但一般是一个很好的起点。
我有一个我用perl编写的程序，它使用一个postgresSQL
数据库作为后端。该计划有效，但表现真的很糟糕。我一直在尽力阅读优化性能，但仍然不是很合理。有一次，我的程序能够在Pentium3 650MHz，448MB RAM
测试机上以16分10秒的速度处理175,000条记录。从那以后我得到了Pentium3 1GHz，512MB系统，我已经尝试了很多东西来提高性能，但是现在它已经慢了很多，我似乎无法弄明白我是什么做错了。
一些起点：
1. VACUUM FULL
这将确保回收任何未使用的空间
2.分析
这将重新计算表格的统计数据
3.基本执行调整：
http://www.varlena.com/varlena/Gener...bits/index.php
varlena.com上的postgresql.conf文件也有一个很好的指南
在这个列表上寻求我的程序的帮助是否合适？
完全披露：该程序最初不是GPL'，因为它适用于我的公司，但它将免费发布给家庭用户和来源
代码将是提供（类似于其他拆分许可计划）
虽然一旦我的公司赚回钱，我认为他们将完全GPL
它（我在老板的情况下： p）。
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.
No problem. Reading your message below, you might want to try the
performance list, but general is a good place to start.
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.
A few places to start:
1. VACUUM FULL
This will make sure any unused space is reclaimed
2. ANALYZE
This will recalculate stats for the tables
3. Basic performce tuning:
http://www.varlena.com/varlena/Gener...bits/index.php
There''s also a good guide to the postgresql.conf file on varlena.com
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 ).
没问题 - w如果你担心你的软件许可证。一旦你已经采取了上述基本步骤，尝试选择一个你认为太慢的特定
查询并提供：
1. PostgreSQL版本
2.基本硬件信息（如你所示）
3.表格大小。
4. EXPLAIN ANALYZE的输出<在这里查询>
EXPLAIN ANALYZE运行查询并显示PG认为它有多少工作
将是多少和多少它实际上是原来的。
HTH
-
Richard Huxton
Archonet Ltd
---------------------------（播出结束）------ ---------------------
提示6：您是否搜索了我们的列表档案？
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
这篇关于新的列表;这是一个好问题吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
