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 23C059DC877 for ; Wed, 22 Feb 2006 14:11:22 -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 56952-02 for ; Wed, 22 Feb 2006 14:11:21 -0400 (AST) X-Greylist: delayed 00:44:23.922466 by SQLgrey- Received: from zeus.liquidweb.com (zeus.liquidweb.com [64.91.224.170]) by postgresql.org (Postfix) with ESMTP id DA71F9DC838 for ; Wed, 22 Feb 2006 14:11:18 -0400 (AST) Received: from cpusoftw by zeus.liquidweb.com with local (Exim 4.52) id 1FBySH-0005Rw-1H; Wed, 22 Feb 2006 13:11:13 -0500 From: "ryan groth" To: "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:11:13 -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/350 X-Sequence-Number: 17336 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 > > --