X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 639D59FA48D for ; Wed, 13 Sep 2006 11:03:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 11043-06 for ; Wed, 13 Sep 2006 14:03:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (Postfix) with SMTP id 3340C9FA20E for ; Wed, 13 Sep 2006 11:03:15 -0300 (ADT) Received: (qmail 21253 invoked from network); 13 Sep 2006 14:03:13 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.2?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 13 Sep 2006 14:03:13 -0000 In-Reply-To: <20060913125013.3321.qmail@web35806.mail.mud.yahoo.com> References: <20060913125013.3321.qmail@web35806.mail.mud.yahoo.com> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: sql-bench Date: Wed, 13 Sep 2006 10:03:12 -0400 To: yoav x X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/117 X-Sequence-Number: 20803 First of all you are going to have to show use what these queries are exactly, what the machine is you are running on (CPU, memory, and disk) , and how you have tuned it. slow is a relative term.. we need information to determine what "slow" means. Dave On 13-Sep-06, at 8:50 AM, yoav x wrote: > So why are these queries so slow in PG? > > > --- Dave Cramer wrote: > >> All of the tuning parameters would affect all queries >> >> shared buffers, wal buffers, effective cache, to name a few >> >> --dc-- >> On 13-Sep-06, at 8:24 AM, yoav x wrote: >> >>> Hi >>> >>> I am trying to run sql-bench against PostgreSQL 8.1.4 on Linux. >>> Some of the insert tests seems to be ver slow >>> >>> For example: select_join_in >>> >>> Are there any tuning parameters that can be changed to speed these >>> queries? Or are these queries >>> especially tuned to show MySQL's stgrenths? >>> >>> >>> >>> >>> __________________________________________________ >>> Do You Yahoo!? >>> Tired of spam? Yahoo! Mail has the best spam protection around >>> http://mail.yahoo.com >>> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 9: In versions below 8.0, the planner will ignore your desire to >>> choose an index scan if your joining column's datatypes do >>> not >>> match >>> >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 1: if posting/reading through Usenet, please send an appropriate >> subscribe-nomail command to majordomo@postgresql.org so >> that your >> message can get through to the mailing list cleanly >> > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >