From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Dann Corbit <DCorbit(at)connx(dot)com> |
Cc: | Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)com>, Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Views- Advantages and Disadvantages |
Date: | 2007-05-09 20:24:56 |
Message-ID: | 46422E18.1040808@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dann Corbit wrote:
>> -----Original Message-----
>> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
>> owner(at)postgresql(dot)org] On Behalf Of Ashish Karalkar
>> Sent: Wednesday, May 09, 2007 1:36 AM
>> To: Andrej Ricnik-Bay; Ron Johnson
>> Cc: pgsql-general(at)postgresql(dot)org
>> Subject: Re: [GENERAL] Views- Advantages and Disadvantages
>>
>> Thanks All for your replies,
>>
>> But then dont we have any disadvantage of using View???
>
> Views can hide important information from the optimizer (especially
> index information).
I don't believe that is true in PostgreSQL's case.
Joshua D. Drake
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-05-09 20:26:07 | Re: Views- Advantages and Disadvantages |
Previous Message | John DeSoi | 2007-05-09 20:19:47 | Re: User restrictions |