From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org, <pgsql-performance(at)postgresql(dot)org>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | An unresolved performance problem. |
Date: | 2003-05-07 16:33:24 |
Message-ID: | Pine.LNX.4.44.0305071359180.27590-100000@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-performance pgsql-sql |
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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-05-07 16:57:22 | Re: Unanswered Questions WAS: An unresolved performance problem. |
Previous Message | scott.marlowe | 2003-05-07 15:42:27 | Re: An unresolved performance problem. |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-05-07 16:57:22 | Re: Unanswered Questions WAS: An unresolved performance problem. |
Previous Message | Bruno Wolff III | 2003-05-07 16:28:15 | Re: Yet another 'why does it not use my index' question. |
From | Date | Subject | |
---|---|---|---|
Next Message | Jon Earle | 2003-05-07 16:35:43 | PostgreSQL Qs |
Previous Message | Tom Lane | 2003-05-07 16:13:05 | Re: Date Anomaly?? |