Re: Outer join query plans and performance

From: Rich Doughty <rich(at)opusvl(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Outer join query plans and performance
Date: 2005-10-24 12:58:18
Message-ID: 435CDA6A.6090801@opusvl.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rich Doughty wrote:
> I'm having some significant performance problems with left join. Can
> anyone give me any pointers as to why the following 2 query plans are so
> different?

[snip]

knew i'd forgotten something...

select version();
version

--------------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.2
20050821 (prerelease) (Debian 4.0.1-6)

--

- Rich Doughty

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sailer, Denis (YBUSA-CDR) 2005-10-24 13:52:29 cannot stat `/usr/local/pgsql/data/pg_xlog/00000001000000430000009C': No such file or directory
Previous Message Rich Doughty 2005-10-24 12:42:16 Outer join query plans and performance