| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: On columnar storage |
| Date: | 2015-06-17 18:04:31 |
| Message-ID: | 20150617180431.GZ133018@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Jim Nasby wrote:
> Related to idea of an 'auto join', I do wish we had the ability to access
> columns in a referenced FK table from a referring key; something like SELECT
> customer_id.first_name FROM invoice (which would be translated to SELECT
> first_name FROM invoice JOIN customer USING( customer_id )).
We already have this feature -- you just need to set the
add_missing_from GUC.
(... actually we removed that feature because it was considered
dangerous or something.)
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brendan Jurd | 2015-06-17 18:24:26 | Re: [PATCH] Function to get size of asynchronous notification queue |
| Previous Message | Tomas Vondra | 2015-06-17 17:52:46 | pretty bad n_distinct estimate, causing HashAgg OOM on TPC-H |