On Tue, Oct 27, 2009 at 5:11 PM, fox7 <ale_shark7@xxxxxxxx> wrote: > > 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 PostgreSQL. > I have tries this: > CREATE INDEX View1_index > ON View1 > USING btree > (term1); 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) merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
