Re: Tuning to speed select

From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: "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:35:54
Message-ID: 7be3f35d0608091235n6077b1f1r26391bf40792b691@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Louis,

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)

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Let's set so double the killer delete select all.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-08-09 19:41:13 Re: WIN32 Build?
Previous Message Shoaib Mir 2006-08-09 19:30:10 Re: WIN32 Build?