Re: Views, views, views: Summary of Arguments

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: elein(at)varlena(dot)com (elein)
Cc: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Views, views, views: Summary of Arguments
Date: 2005-05-12 19:30:59
Message-ID: 11695.1115926259@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

elein(at)varlena(dot)com (elein) writes:
> Also, if you do not trust the newsysview team to develop good views
> (with input for hackers), how can you possibly expect every dba and tool
> maker to access the system catalog in a consistent and accurate manner.

I never said that they couldn't develop useful views. I do question
the assumption that they can be all things to all people. I think the
claims being made in this thread are highly overblown. In particular
I doubt that views that expose everything anyone might want to know
are going to be amazingly much simpler than the underlying catalogs.

So far the goals that have been presented include being complete, being
simple, and being stabler than the underlying catalogs. I think you
can have *one* of those; probably not two and definitely not all three.
So tell us the truth about what your priorities are and which goals will
lose when there's a conflict.

I see a whole lot of NIH (Not Invented Here) syndrome --- the developers
of these views love 'em, sure, because they fit the way those developers
think. But that doesn't prove everyone else will love 'em.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2005-05-12 19:45:23 Re: Views, views, views: Summary of Arguments
Previous Message Victor Y. Yegorov 2005-05-12 19:21:08 Best way to scan on-disk bitmaps