X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C07945348D for ; Thu, 24 Mar 2005 19:53:45 +0000 (GMT) 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 46865-08 for ; Thu, 24 Mar 2005 19:53:42 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.194]) by svr1.postgresql.org (Postfix) with ESMTP id 8921553475 for ; Thu, 24 Mar 2005 19:53:41 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id j1so583080rnf for ; Thu, 24 Mar 2005 11:53:43 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:reply-to:from:to:cc:subject:date:mime-version:content-type:content-transfer-encoding:x-mailer:in-reply-to:thread-index:x-mimeole:message-id; b=oESR5+TLTvn3J/7wNWTGI1gfIIDwNFf98wS3raLai3lWyBO+8WFP7xRfqKPUrWXim2WlZqewiZSUnqAi+qi0Anc4un+FmT7WY3vUG/vuP7aTcNqQTmoeRCNZgSECnn1Ig03cOZ+6GA7XozYkRN4a7uVcmbpHd1wtP1BWRzicBbc= Received: by 10.38.181.47 with SMTP id d47mr1881215rnf; Thu, 24 Mar 2005 11:53:43 -0800 (PST) Received: from MATTSPC ([12.216.69.41]) by mx.gmail.com with ESMTP id h19sm626341rnb.2005.03.24.11.53.42; Thu, 24 Mar 2005 11:53:42 -0800 (PST) Reply-To: From: "Matthew Nuzum" To: "'Tom Lane'" Cc: Subject: Re: Preventing query from hogging server Date: Thu, 24 Mar 2005 13:53:37 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 In-Reply-To: <5050.1111693395@sss.pgh.pa.us> Thread-Index: AcUwqbx/GU33eBYDRwmNhg/1AK79RAAAKvtg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-ID: <42431ac6.29dd6143.2b52.ffffbf08@mx.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.304 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200503/517 X-Sequence-Number: 11222 > How many rows in usage_access? How many groups do you expect? > (Approximate answers are fine.) What PG version is this, and > what's your sort_mem setting? > > regards, tom lane I believe there are about 40,000,000 rows, I expect there to be about 10,000,000 groups. PostgreSQL version is 7.3.2 and the sort_mem is at the default setting. (I know that's an old version. We've been testing with 7.4 now and are nearly ready to upgrade.) -- Matthew Nuzum www.followers.net - Makers of "Elite Content Management System" View samples of Elite CMS in action by visiting http://www.followers.net/portfolio/