From: Richard Broersma Jr <rabroersma@yahoo.com>
To: radhika@88thstreet.com
To: pgsql-sql@postgresql.org
Subject: Re: Temp tbl Vs. View
Date: Thu, 29 Mar 2007 08:46:12 -0700 (PDT)
Message-ID: <353111.48354.qm@web31815.mail.mud.yahoo.com> (raw)
In-Reply-To: <60666.63.118.86.10.1175181985.squirrel@www.88thstreet.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rabroersma@yahoo.com, radhika@88thstreet.com
Subject: Re: Temp tbl Vs. View
In-Reply-To: <353111.48354.qm@web31815.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox