From: scott.marlowe <scott.marlowe@ihs.com>
To: johnnnnnn <john@phaedrusdeinus.org>
Cc: Sean Chittenden <sean@chittenden.org>
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
Date: Thu, 8 May 2003 10:20:19 -0600 (MDT)
Message-ID: <Pine.LNX.4.33.0305081019300.11328-100000@css120.ihs.com> (raw)
In-Reply-To: <20030508144738.GA18774@performics.com>
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 :-)
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: scott.marlowe@ihs.com, john@phaedrusdeinus.org, sean@chittenden.org, pgsql-performance@postgresql.org, pgsql-bugs@postgresql.org
Subject: Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance
In-Reply-To: <Pine.LNX.4.33.0305081019300.11328-100000@css120.ihs.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