From: | merlyn(at)stonehenge(dot)com (Randal L(dot) Schwartz) |
---|---|
To: | "Thurstan R(dot) McDougle" <trmcdougle(at)my-deja(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Tupple statistics function |
Date: | 2001-09-24 15:06:59 |
Message-ID: | m18zf4vd9o.fsf@halfdome.holdit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
>>>>> "Thurstan" == Thurstan R McDougle <trmcdougle(at)my-deja(dot)com> writes:
Thurstan> In general EXPLAIN could be expanded to be a command to
Thurstan> return an explanation and stats of many items. There could
Thurstan> also be EXPLAIN that only shows fields and EXPLAIN VERBOSE
Thurstan> that also shows more detail such as stats (as that tends to
Thurstan> take more time to collect).
It would also be interesting to take everything that psql does and put
each of them into a view so that it could be queried directly.
There's no reason that the magic should reside in client-side code.
It'd also make psql much simpler. :) I mean, why is "\d" anything
other than "select * from pg_table_view;", with all the logic to
compute that table in the view code?
Unless having a view on the server is expensive. Is a server view
expensive if nobody calls it? I mean, it's not maintained like an
index, is it?
--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn(at)stonehenge(dot)com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!
From | Date | Subject | |
---|---|---|---|
Next Message | Haris Peco | 2001-09-24 15:38:25 | Replication of distributed databases & pgsql 7.2 |
Previous Message | Niall Litchfield | 2001-09-24 11:39:56 | Re: NewYork Bombing: SQL server bomb proof!! |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2001-09-24 15:11:59 | Re: Bug?: Update on ancestor for a row of a child |
Previous Message | Hannu Krosing | 2001-09-24 15:03:38 | Re: Changing data types |