pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Unanswered Questions WAS: An unresolved performance problem.
6+ messages / 6 participants
[nested] [flat]
* Re: Unanswered Questions WAS: An unresolved performance problem.
@ 2003-05-07 16:57 Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 6+ messages in thread
From: Josh Berkus @ 2003-05-07 16:57 UTC (permalink / raw)
To: Mendola Gaetano <mendola@bigfoot.com>; Achilleus Mantzios <achill@matrix.gatewaynet.com>; pgsql-sql; pgsql-performance@postgresql.org; pgsql-bugs@postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [SQL] Unanswered Questions WAS: An unresolved performance problem.
@ 2003-05-07 23:52 Randall Lucas <rlucas@tercent.net>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 6+ messages in thread
From: Randall Lucas @ 2003-05-07 23:52 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: Mendola Gaetano <mendola@bigfoot.com>; Achilleus Mantzios <achill@matrix.gatewaynet.com>; pgsql-sql; pgsql-performance@postgresql.org; pgsql-bugs@postgresql.org
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@postgresql.org
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem.
@ 2003-05-08 04:13 Tom Lane <tgl@sss.pgh.pa.us>
parent: Randall Lucas <rlucas@tercent.net>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2003-05-08 04:13 UTC (permalink / raw)
To: Randall Lucas <rlucas@tercent.net>; +Cc: josh@agliodbs.com, "Mendola Gaetano" <mendola@bigfoot.com>; Achilleus Mantzios <achill@matrix.gatewaynet.com>; pgsql-sql; pgsql-performance@postgresql.org; pgsql-bugs@postgresql.org
Randall Lucas <rlucas@tercent.net> writes:
> 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).
That's always been a problem, but it does seem to have been getting
worse lately.
> 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.
The idea of some canned guidance doesn't seem bad, but I'm not sure if
it should be off-list or not. If newbies are corrected off-list then
other newbies who might be lurking, or reading the archives, don't learn
any better and will make the same mistakes in their turn.
How about a standard answer of "you haven't really provided enough info
for us to be helpful, please see this-URL for some hints"? That would
avoid bulking up the list archives with many copies, yet at the same
time the archives would provide evidence of the existence of hints...
> Thoughts? Josh and I have placed a draft at
> http://techdocs.postgresql.org/guides/SlowQueryPostingGuidelines
Looks good, though I concur with Stephan's comment that the table
schemas aren't optional.
It might be worth including a checklist of the standard kinds of errors
(for example, datatype mismatch preventing index usage). Come to think
of it, that starts to make it look like a FAQ list directed towards
performance issues. Maybe we could make this a subsection of the main
FAQ?
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem.
@ 2003-05-08 04:57 Sean Chittenden <sean@chittenden.org>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Sean Chittenden @ 2003-05-08 04:57 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Randall Lucas <rlucas@tercent.net>; josh@agliodbs.com, Mendola Gaetano <mendola@bigfoot.com>; Achilleus Mantzios <achill@matrix.gatewaynet.com>; pgsql-sql; pgsql-performance@postgresql.org; pgsql-bugs@postgresql.org
> > 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).
>
> That's always been a problem, but it does seem to have been getting
> worse lately.
I hate to point this out, but "TIP 4" is getting a bit old and the 6
tips that we throw out to probably about 40K people about 1-200 times
a day have probably reached saturation. Without looking at the
archives, I bet anyone a shot of good scotch that, it's probably
pretty infrequent that people don't kill -9 their postmasters.
Any chance we could flush out the TIPs at the bottom to include,
"VACUUM ANALYZE your database regularly," or "When reporting a
problem, include the output from EXPLAIN [query]," or "ANALYZE tables
before examining the output from an EXPLAIN [query]," or "Visit [url]
for a tutorial on (schemas|triggers|views)."
-sc
--
Sean Chittenden
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem.
@ 2003-05-08 14:47 johnnnnnn <john@phaedrusdeinus.org>
parent: Sean Chittenden <sean@chittenden.org>
0 siblings, 1 reply; 6+ messages in thread
From: johnnnnnn @ 2003-05-08 14:47 UTC (permalink / raw)
To: Sean Chittenden <sean@chittenden.org>; +Cc: pgsql-sql; pgsql-performance@postgresql.org; pgsql-bugs@postgresql.org
On Wed, May 07, 2003 at 09:57:49PM -0700, Sean Chittenden wrote:
> I hate to point this out, but "TIP 4" is getting a bit old and the 6
> tips that we throw out to probably about 40K people about 1-200
> times a day have probably reached saturation. Without looking at
> the archives, I bet anyone a shot of good scotch that, it's probably
> pretty infrequent that people don't kill -9 their postmasters.
>
> Any chance we could flush out the TIPs at the bottom to include,
> "VACUUM ANALYZE your database regularly," or "When reporting a
> problem, include the output from EXPLAIN [query]," or "ANALYZE
> tables before examining the output from an EXPLAIN [query]," or
> "Visit [url] for a tutorial on (schemas|triggers|views)."
Better yet, have TIPs that are appropriate to the subscribed
list. -performance has different posting guidelines, things to try,
etc. than does -bugs, than does -sql (than does -hackers, than does
-interfaces, ...).
I don't know how feasible it is to separate them out, but i think it's
worth looking into.
-johnnnnnnnnnnn
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance
@ 2003-05-08 16:20 scott.marlowe <scott.marlowe@ihs.com>
parent: johnnnnnn <john@phaedrusdeinus.org>
0 siblings, 0 replies; 6+ messages in thread
From: scott.marlowe @ 2003-05-08 16:20 UTC (permalink / raw)
To: johnnnnnn <john@phaedrusdeinus.org>; +Cc: Sean Chittenden <sean@chittenden.org>; pgsql-sql; pgsql-performance@postgresql.org; pgsql-bugs@postgresql.org
On Thu, 8 May 2003, johnnnnnn wrote:
> On Wed, May 07, 2003 at 09:57:49PM -0700, Sean Chittenden wrote:
> > I hate to point this out, but "TIP 4" is getting a bit old and the 6
> > tips that we throw out to probably about 40K people about 1-200
> > times a day have probably reached saturation. Without looking at
> > the archives, I bet anyone a shot of good scotch that, it's probably
> > pretty infrequent that people don't kill -9 their postmasters.
> >
> > Any chance we could flush out the TIPs at the bottom to include,
> > "VACUUM ANALYZE your database regularly," or "When reporting a
> > problem, include the output from EXPLAIN [query]," or "ANALYZE
> > tables before examining the output from an EXPLAIN [query]," or
> > "Visit [url] for a tutorial on (schemas|triggers|views)."
>
> Better yet, have TIPs that are appropriate to the subscribed
> list. -performance has different posting guidelines, things to try,
> etc. than does -bugs, than does -sql (than does -hackers, than does
> -interfaces, ...).
>
> I don't know how feasible it is to separate them out, but i think it's
> worth looking into.
Agreed.
Also, some tips might well cross over, like say, vacuum and analyze
regularly. Hmmm. Sounds like a job for a relational database :-)
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2003-05-08 16:20 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-07 16:57 Re: Unanswered Questions WAS: An unresolved performance problem. Josh Berkus <josh@agliodbs.com>
2003-05-07 23:52 ` Randall Lucas <rlucas@tercent.net>
2003-05-08 04:13 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-05-08 04:57 ` Sean Chittenden <sean@chittenden.org>
2003-05-08 14:47 ` johnnnnnn <john@phaedrusdeinus.org>
2003-05-08 16:20 ` Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance scott.marlowe <scott.marlowe@ihs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox