Skip site navigation (1) Skip section navigation (2)

Re: JOIN performance

From: "Dean Gibson (DB Administrator)" <postgresql3(at)ultimeth(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: JOIN performance
Date: 2004-09-21 04:41:40
Message-ID: 5.1.0.14.2.20040920213442.00ae4450@imaps.mailpen.net (view raw or flat)
Thread:
Lists: pgsql-sql
It turns out that even when I removed the CASE statement from the VIEW, the 
performance problem remained.  I had to remove the conditional as well from 
the VIEW.

To refresh your memory, there was this line in the VIEW (said VIEW being 
the subject of the LEFT JOIN):

cancel_date < expire_date AS canceled,

(cancel_date & expire_date are DATEs in the base view)

When I removed the above line from the VIEW, the performance problem 
disappeared.

Do you know why?  I'm running 7.3.4, by the way.

-- Dean


In response to

Responses

pgsql-sql by date

Next:From: Joe ConwayDate: 2004-09-21 04:44:02
Subject: Re: PL/pgSQL multidimension (matrix) array in function
Previous:From: Tom LaneDate: 2004-09-21 04:10:13
Subject: Re: JOIN performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group