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: (view raw, whole thread or download thread mbox)
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


Doug Silver
Network Manager
Urchin Corporation

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-2017 The PostgreSQL Global Development Group