X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 8E76D9250E4; Wed, 28 May 2003 07:28:52 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 05562-05; Wed, 28 May 2003 07:28:51 -0400 (EDT) Received: from mta06bw.bigpond.com (mta06bw.bigpond.com [139.134.6.96]) by developer.postgresql.org (Postfix) with ESMTP id 874A89250F7; Wed, 28 May 2003 07:28:49 -0400 (EDT) Received: from rabbit.sspl.net.au ([144.135.24.69]) by mta06bw.bigpond.com (Netscape Messaging Server 4.15 mta06bw Jul 16 2002 22:47:55) with SMTP id HFLH7600.785; Wed, 28 May 2003 21:28:18 +1000 Received: from cpe-203-51-24-209.nsw.bigpond.net.au ([203.51.24.209]) by bwmam01bpa.bigpond.com(MAM $Name: REL_3_3_2a $ 8/1553876); 28 May 2003 21:28:18 Received: by rabbit.sspl.net.au (Postfix, from userid 1000) id A2FC72EC76; Wed, 28 May 2003 21:28:15 +1000 Date: Wed, 28 May 2003 21:28:15 +1000 From: Peter Lavender To: pgsql-sql@postgresql.org, pgsql-performance@postgresql.org Message-ID: <20030528112815.GD816@piglet2> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.28i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/229 X-Sequence-Number: 2008 pgsql-bugs@postgresql.org Cc: Bcc: Subject: Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance Reply-To: plaven@bigpond.net.au In-Reply-To: X-Operating-System: Linux/2.4.18-686-smp (i686) X-Uptime: 21:03:03 up 8 days, 22:55, 8 users, load average: 1.00, 1.00, 1.00 * scott.marlowe (scott.marlowe@ihs.com) wrote: > On Thu, 8 May 2003, johnnnnnn wrote: > > > > I hate to point this out, but "TIP 4" is getting a bit old and the 6 > > Also, some tips might well cross over, like say, vacuum and analyze > regularly. Hmmm. Sounds like a job for a relational database :-) Did this get carried any further? I'd love to see something come out of it. But I'd really like to see more of the kind of tricks and tips, like how to dump all databases using a script of 3 lines(?) I'm sure I've seen it before. The extra lines I don't think would be a major pain given the added value. Even if it's too much, how about somewhere on techdocs for the script and a link in the tips 'n tricks line? Pete :wq