DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=cYHLVj/P0yYVGiLIZ441+/57e/fX9FW4F1nvCe9c+JFM1ri2pE9TbqrtIZ9FmPxIratTEi6R9JhuoAXZr7g5AJ5n/2jy5U2bImHJDaHG/ur5KoLan6fY2bu1/DpWgj6gwh1eVzGdBRmu5QHEx0G9EXIC0LOep65MdqGeU1lWWgQ=;
Date: Thu, 29 Mar 2007 08:46:12 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: Temp tbl Vs. View
To: radhika@88thstreet.com, pgsql-sql@postgresql.org
In-Reply-To: <60666.63.118.86.10.1175181985.squirrel@www.88thstreet.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <353111.48354.qm@web31815.mail.mud.yahoo.com>


> select from the view is taking a lot of time (7000 ms) as per explain
> analyze. Both the primary and secondary tables have about 400,000 rows.
> 
> My question is how can I fix this?
> Would it be better to create a temporary table for just daily data and
> have the view for more extended queries? Any other design ideas?

Perhaps tsearch2 would work for you.  I am just starting to learn about it.  Maybe you can create
a tsearch2 GIN index on each table in the view, and then use tsearch2 queries to quickly retrieve
your results.

Regards,
Richard Broersma Jr.