Re: Tuning to speed select

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>, louis gonzales <gonzales(at)linuxlouis(dot)net>
Cc: Tom Laudeman <twl8n(at)virginia(dot)edu>, pgsql-general(at)postgresql(dot)org
Subject: Re: Tuning to speed select
Date: 2006-08-09 19:42:54
Message-ID: 20060809194254.80193.qmail@web31809.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Views certainly help in managing complexity. They do nothing to improve
> query-speed.
>
> Querying a view gets rewritten to queries to the underlying tables on the
> fly.
> (as long as there are no materialized views, which are still on a the TODO
> list)

Would partial indexs on the most queried regions of the table help in query speed?

Regards,

Richard Broersma Jr.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DEV 2006-08-09 19:45:15 Re: WIN32 Build?
Previous Message Bruce Momjian 2006-08-09 19:41:13 Re: WIN32 Build?