Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: johnnnnnn <john(at)phaedrusdeinus(dot)org>
Cc: Sean Chittenden <sean(at)chittenden(dot)org>,<pgsql-sql(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance
Date: 2003-05-08 16:20:19
Message-ID: Pine.LNX.4.33.0305081019300.11328-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-performancepgsql-sql
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 :-)


In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2003-05-08 16:25:07
Subject: Re: Type casting and indexes
Previous:From: Stephan SzaboDate: 2003-05-08 16:13:29
Subject: Re: Type casting and indexes

pgsql-bugs by date

Next:From: Reece HartDate: 2003-05-08 21:24:32
Subject: pg_dump session authorization fails during restore
Previous:From: johnnnnnnDate: 2003-05-08 14:47:38
Subject: Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem.

pgsql-sql by date

Next:From: Bryan KlimtDate: 2003-05-08 16:41:04
Subject: Re: insert rowtype
Previous:From: mallahDate: 2003-05-08 15:45:32
Subject: Re: PROBLEM WITH UPDATE COMMAND

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group