An unresolved performance problem.
От | Achilleus Mantzios |
---|---|
Тема | An unresolved performance problem. |
Дата | |
Msg-id | Pine.LNX.4.44.0305071359180.27590-100000@matrix.gatewaynet.com обсуждение исходный текст |
Ответы |
Re: An unresolved performance problem.
Re: An unresolved performance problem. |
Список | pgsql-performance |
Hi, few days ago, i posted some really wierd (at least to me) situation (maybe a potentian bug) to the performance and bugs list and to some core hacker(s) privately as well, and i got no response. Moreover i asked for some feedback in order to understand/fix the problem myself, and again received no response. What i asked was pretty simple: "1. Is it possible that the absense of statistics make the planer produce better plans than in the case of statistcs generated with vacuum analyze/analyze? 2. If No, i found a bug, 3. If yes then under what conditions?? 4. If no person knows the answer or no hacker wants to dig into the problem then is there a direction i must follow to understand/fix whats going on myself??"" Pretty straight i think. Well, i stack on step 1. It seemed to me that either my question was too naive to deserve some real investigation (doubtedly), or no one was in a position to comment on it (doubtedly), or that it is not considered an interesting case (possible), or that some people move all the mail i send to the lists to /dev/null (unfortunately possible too). So Since i really have stuck to postgresql for over 2 years for both technical and emotional reasons, i would feel much more confident if i would reach step 2 or greater. The table i have in question is a critical one in my application since it monitors important plan maintenance data, and i have to move on with this problem. Thanx P.S. the www (64.49.215.82) server is down for while. -- ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-210-8981112 fax: +30-210-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr
В списке pgsql-performance по дате отправления: