From: Sean Chittenden <sean@chittenden.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Randall Lucas <rlucas@tercent.net>
Cc: josh@agliodbs.com, Mendola Gaetano <mendola@bigfoot.com>
Cc: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-performance@postgresql.org
Cc: pgsql-bugs@postgresql.org
Subject: Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem.
Date: Wed, 7 May 2003 21:57:49 -0700
Message-ID: <20030508045749.GV49916@perrin.int.nxad.com> (raw)
In-Reply-To: <17063.1052367200@sss.pgh.pa.us>
References: <F73D918C-80E6-11D7-A71E-000A957653D6@tercent.net>
<17063.1052367200@sss.pgh.pa.us>
> > 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sean@chittenden.org, tgl@sss.pgh.pa.us, rlucas@tercent.net, mendola@bigfoot.com, achill@matrix.gatewaynet.com, pgsql-performance@postgresql.org, pgsql-bugs@postgresql.org
Subject: Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem.
In-Reply-To: <20030508045749.GV49916@perrin.int.nxad.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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