Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Temp tbl Vs. View
- From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
- To: radhika(at)88thstreet(dot)com, pgsql-sql(at)postgresql(dot)org
- Subject: Re: Temp tbl Vs. View
- Date: Thu, 29 Mar 2007 08:46:12 -0700 (PDT)
> 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.
- References:
- Temp tbl Vs. View
- From: Radhika Sambamurti
- Temp tbl Vs. View
- Prev by Date: Temp tbl Vs. View
- Next by Date: Re: Temp tbl Vs. View
- Previous by thread: Temp tbl Vs. View
- Next by thread: Re: Temp tbl Vs. View
- Indexes: