X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 138C79DC93E for ; Wed, 22 Feb 2006 14:21:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57005-08 for ; Wed, 22 Feb 2006 14:21:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from zeus.liquidweb.com (zeus.liquidweb.com [64.91.224.170]) by postgresql.org (Postfix) with ESMTP id 80F139DC838 for ; Wed, 22 Feb 2006 14:21:11 -0400 (AST) Received: from cpusoftw by zeus.liquidweb.com with local (Exim 4.52) id 1FBybo-0005wh-Vn; Wed, 22 Feb 2006 13:21:05 -0500 From: "ryan groth" To: "ryan groth" , "Steinar H. Gunderson" , pgsql-performance@postgresql.org Subject: Re: Joins and full index scans...mysql vs postgres? X-Mailer: NeoMail 1.27 X-IPAddress: 127.0.0.1 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Message-Id: Date: Wed, 22 Feb 2006 13:21:04 -0500 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - zeus.liquidweb.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [32069 32069] / [47 12] X-AntiAbuse: Sender Address Domain - cpusoftware.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200602/351 X-Sequence-Number: 17337 workmem is set to the default, increasing it decreases performance. > Does this work: > > "Merge Left Join (cost=0.00..2656.36 rows=6528 width=1522) (actual > time=0.057..123.659 rows=6528 loops=1)" > " Merge Cond: ("outer".uid = "inner".uid)" > " -> Merge Left Join (cost=0.00..1693.09 rows=6528 width=1264) > (actual time=0.030..58.876 rows=6528 loops=1)" > " Merge Cond: ("outer".uid = "inner".user_id)" > " -> Index Scan using users_pkey on users (cost=0.00..763.81 > rows=6528 width=100) (actual time=0.016..9.446 rows=6528 loops=1)" > " -> Index Scan using phorum_users_base_pkey on > phorum_users_base (cost=0.00..822.92 rows=9902 width=1168) (actual > time=0.007..15.674 rows=9845 loops=1)" > " -> Index Scan using useraux_pkey on useraux (cost=0.00..846.40 > rows=7582 width=262) (actual time=0.007..11.935 rows=7529 loops=1)" > "Total runtime: 127.442 ms" > > > > On Wed, Feb 22, 2006 at 12:26:47PM -0500, ryan groth wrote: > > > Postgres Explain > > > > We need to see EXPLAIN ANALYZE results here. > > > > What's your work_mem set to? > > > > /* Steinar */ > > -- > > Homepage: http://www.sesse.net/ > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faq > > > > > > -- > > > > On Wed, Feb 22, 2006 at 12:26:47PM -0500, ryan groth wrote: > > > Postgres Explain > > > > We need to see EXPLAIN ANALYZE results here. > > > > What's your work_mem set to? > > > > /* Steinar */ > > -- > > Homepage: http://www.sesse.net/ > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faq > > > > > > -- > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > > --