An unresolved performance problem.

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

Responses

Browse pgsql-bugs by date

  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.

Browse pgsql-performance by date

  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.

Browse pgsql-sql by date

  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??