[GENERAL] Slow running query with views...how to increase efficiency? with index?

Hi, I'm a new user... First of all excuse me for the bad english... :confused: I have a great problem! I have to do some little query with views, but the views contain thousand and thousand of records. Searching online I have found somthing about view index, but I don't know the right syntax for P

Re: [GENERAL] Slow running query with views...how to increase efficiency? with index?

Views do not help or hurt performance. Views encapsulate complex queries. If you have a slow running query, the usual way to get help is to post: *) explain analyze results (most important) *) the query (important) *) interesting tables/indexes (somewhat important) -- These

Re: [GENERAL] Slow running query with views...how to increase efficiency? with index?

Alban Hertroys-3 wrote: > > On 28 Oct 2009, at 9:57, fox7 wrote: > > You forgot to show us the most important part. > --- > Do you absolutely need to order the output of your views? You could > just order the results of your queries on your views instead. The way

Re: [GENERAL] Slow running query with views...how to increase efficiency? with index?

Alban Hertroys-3 wrote: > >> What do you mean for analyze results? > http://www.postgresql.org/docs/8.4/interactive/sql-explain.html > thanks... Now I try and put here the results... However I'm using Postgre 8.3, not 8.4... ...but I don't think this is the problem! -- View this message in c

Re: [GENERAL] Slow running query with views...how to increase efficiency? with index?

I copy the results derived by istruction "EXPLAIN ANALYZE" for the two query... --Query without views- "Unique (cost=406.58..407.13 rows=73 width=114) (actual time=1.262..1.448 rows=40 loops=1)" " -> Sort (cost=406.58..406.77 rows=73 width=114) (act