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

faster join access?

From: Doug Silver <dsilver(at)urchin(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: faster join access?
Date: 2002-04-25 22:22:04
Message-ID: Pine.LNX.4.21.0204251517360.23049-100000@danzig.sd.quantified.net (view raw or flat)
Thread:
Lists: pgsql-novice
I need to access the same information across two tables but the date
changes as different intervals are selected (this is for a web page).  So,
I thought creating a view would help speed things up, but upon doing an
'explain', I realized that's not the case.  So, would it be best to create
a trigger that updates a separate table whenever information is changed on
the other two?  That way I can do an easy select on table #3 without the
join.

Thanks!

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Silver
Network Manager
Urchin Corporation	http://www.urchin.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


pgsql-novice by date

Next:From: Tom LaneDate: 2002-04-25 22:46:19
Subject: Re: Index on wildcard text search
Previous:From: Lewis BergmanDate: 2002-04-25 21:40:34
Subject: How to do a strange constraint

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