X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 56FD847644D for ; Fri, 11 Apr 2003 13:38:32 -0400 (EDT) Received: from torque.intervideoinc.com (mail.intervideo.com [206.112.112.151]) by postgresql.org (Postfix) with ESMTP id 27E6147651D for ; Fri, 11 Apr 2003 13:33:48 -0400 (EDT) Received: from ronpc [63.68.5.2] by torque.intervideoinc.com (SMTPD32-5.05) id A13F233100F2; Fri, 11 Apr 2003 10:54:07 -0700 From: "Ron Mayer" To: "Josh Berkus" , "Matthew Nuzum" , "'Pgsql-Performance'" Cc: Subject: Re: Caching (was Re: choosing the right platform) Date: Fri, 11 Apr 2003 10:25:24 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal In-Reply-To: <200304110915.15060.josh@agliodbs.com> X-Spam-Status: No, hits=-14.8 required=5.0 tests=BAYES_20,IN_REP_TO,MSGID_GOOD_EXCHANGE,QUOTED_EMAIL_TEXT, SMTPD_IN_RCVD autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/123 X-Sequence-Number: 1629 Josh wrote: >Ron, >> Below is an example of another real-world query from the same >> reporting system that benefits from a sort_mem over 32M. >> Explain analyze (below) shows a 40% improvement by having >> the sort fit in memory. > >Cool! That's a perfect example of sizing sort_mem for the query. Mind if I >steal it for an article at some point? Gladly! BTW... if you're writing a tuning article, the most interesting one I've seen is: http://otn.oracle.com/oramag/webcolumns/2002/techarticles/scalzo_linux01.html I like how they broke down the process in many steps and measured after each. I'm was intrigued by how much Linux's VM tweaking (vm.bdflush) affected performance mattered as much at the more-commontly tweaked "noatime". Ron