X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 89734D9477 for ; Wed, 5 Oct 2005 00:41:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34930-04 for ; Wed, 5 Oct 2005 03:41:30 +0000 (GMT) Received: from mail.baymountain.com (mail.baymountain.com [8.7.96.19]) by svr1.postgresql.org (Postfix) with SMTP id D0BDCD93DA for ; Wed, 5 Oct 2005 00:41:29 -0300 (ADT) Received: (qmail 3520 invoked by uid 504); 5 Oct 2005 03:41:28 -0000 Received: from emil@baymountain.com by mail.baymountain.com by uid 501 with qmail-scanner-1.16 (spamassassin: 2.53. Clear:SA:0(0.0/7.0):. Processed in 0.270083 secs); 05 Oct 2005 03:41:28 -0000 Received: from unknown (HELO briggspack.com) (emil@briggspack.com@24.211.148.77) by mail.baymountain.com with SMTP; 5 Oct 2005 03:41:27 -0000 From: Emil Briggs Reply-To: emil@baymountain.com Organization: Baymountain, Inc. To: pgsql-performance@postgresql.org Subject: Re: Indexes on ramdisk Date: Tue, 4 Oct 2005 23:41:23 -0400 User-Agent: KMail/1.7.1 References: <200510042109.01849.emil@baymountain.com> <33c6269f0510042023t24175e33vf84d9af609a8ccd7@mail.gmail.com> In-Reply-To: <33c6269f0510042023t24175e33vf84d9af609a8ccd7@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200510042341.23264.emil@baymountain.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.038 required=5 tests=[AWL=-0.013, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/67 X-Sequence-Number: 14835 > Talk about your IO system a bit. There might be obvious ways to improve. > > What System/Motherboard are you using? > What Controller Cards are you using? > What kind of Disks do you have (SATA, SCSI 7.6k 10k 15k) > What denominations (9, 18, 36, 72, 143, 80, 160, 200 240Gig)? > What kind of RAIDs do you have setup (How many drives what stripe sizes, > how many used for what). > What levels of RAID are you using (0,1,10,5,50)? > It's a quad opteron system. RAID controller is a 4 channel LSILogic Megaraid 320 connected to 10 15k 36.7G SCSI disks. The disks are configured in 5 mirrored partitions. The pg_xlog is on one mirror and the data and indexes are spread over the other 4 using tablespaces. These numbers from pg_stat_user_tables are from about 2 hours earlier today on this one table. idx_scan 20578690 idx_tup_fetch 35866104841 n_tup_ins 1940081 n_tup_upd 1604041 n_tup_del 1880424