Re: [SQL] Unanswered Questions WAS: An unresolved performance problem.

From: Randall Lucas <rlucas(at)tercent(dot)net>
To: josh(at)agliodbs(dot)com
Cc: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>, "Achilleus Mantzios" <achill(at)matrix(dot)gatewaynet(dot)com>, <pgsql-sql(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [SQL] Unanswered Questions WAS: An unresolved performance problem.
Date: 2003-05-07 23:52:30
Message-ID: F73D918C-80E6-11D7-A71E-000A957653D6@tercent.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance pgsql-sql

Folks,

I suspect that a good number of fairly simple questions aren't being
answered because they're either misdirected or because the poster
hasn't included an "answerable" question (one with sufficient
information to answer).

A suggestion to partially counter this, at least for "slow query" type
questions, has been put forth. If we make it a social norm on the
pg-lists in general to reply off-list to inadequately descriptive "slow
query" questions with a canned message of helpful guidance, we may be
able to up the level of "answerability" of most questions. Ideally,
this would make the questions more transparent, so that more responses
can come from folks other than the major contributors.

Thoughts? Josh and I have placed a draft at
http://techdocs.postgresql.org/guides/SlowQueryPostingGuidelines

I'd specifically like to hear whether people would suggest more of an
emphasis on heuristics for self-help in such a message, what other info
should be included in a "good" slow query question, and people's
thoughts on the netiquette of the whole idea.

Best,

Randall

On Wednesday, May 7, 2003, at 12:57 PM, Josh Berkus wrote:

> Gaetano,
>
>> I seen around a lot of questions are remaining without any reply,
>> may be in this period the guys like Tom Lane are too busy.
>
> Yes, they are. Currently the major contributors are working hard to
> shape up
> both 7.3.3. and 7.4 (and having a long-running discussion about the
> due date
> for 7.4), so they don't have much time for questions.
>
> And for my part, I'm too busy with my paying job to answer all the
> questions
> that get posted, as I suspect are Stephan and Bruno and several other
> people
> who field newbie questions. Given the flood of requests, I have to
> prioritize ... and a question which is missing several crucial details
> (like
> a copy of the query!!!) is going to get answered way later than a
> question
> which provides all the needed information -- if at all.
>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-05-08 03:26:38 Re: float8 errors in HEAD...
Previous Message Sean Chittenden 2003-05-07 23:17:03 Re: float8 errors in HEAD...

Browse pgsql-performance by date

  From Date Subject
Next Message Manfred Koizar 2003-05-07 23:54:04 Re: Hack around lack of CORRESPONDING BY in EXCEPT?
Previous Message Stephan Szabo 2003-05-07 22:58:51 Re: Hack around lack of CORRESPONDING BY in EXCEPT?

Browse pgsql-sql by date

  From Date Subject
Next Message Kenny Mok 2003-05-08 00:59:49 Type coercion on column in a query
Previous Message Mario Alberto Soto Cordones 2003-05-07 23:21:46 PROBLEM WITH UPDATE COMMAND