Re: Indexing Views

Поиск
Список
Период
Сортировка
Искать

Re: Indexing Views

От:
Jeff Davis <list-pgsql-general@empires.org>
Дата:
>  I am storing intermediate results in a view and then using this view for
> further processing, is it possible to index views in Postgres, if so how?
> Any help will be much appreciated.

I don't think it's possible to store anything at all in a view. A view is just 
a query-rewriting rule that can report data from existing tables, as if the 
view was a table itself (but a view isn't a table).

Put proper indexes on the tables that are involved in the view and it should 
work fine. If you're getting poor performance, report the output of EXPLAIN 
for your query and maybe someone can help you optimize the query (or maybe 
even make the planner better).

Regards,
	Jeff

Re: Indexing Views

От:
frbn <frbn@efbs-seafrigo.fr>
Дата:
sid@questions.com wrote:
> hi,
> 
>  I am storing intermediate results in a view and then using this view for
> further processing, is it possible to index views in Postgres, if so how?
> Any help will be much appreciated.

you can use a temporary table which can be indexed.

Indexing Views

От:
"sid@questions.com" <sbhatt@installs.com>
Дата:
hi,

 I am storing intermediate results in a view and then using this view for
further processing, is it possible to index views in Postgres, if so how?
Any help will be much appreciated.


Sid
FAQ