Re: Q on SELECT column list pushdown from view to table - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Q on SELECT column list pushdown from view to table
Date
Msg-id Z-RuNb6EgVha2qOA@hermes.hilbert.loc
Whole thread Raw
In response to Re: Q on SELECT column list pushdown from view to table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Am Wed, Mar 26, 2025 at 04:36:55PM -0400 schrieb Tom Lane:

> It is intentional that this happens even if the reference to
> private_col is subsequently optimized away.  To do otherwise
> would make implementation artifacts in the optimizer far too
> visible, and there's also a very strong case that it would
> violate the SQL standard.

That's what I wanted to know.

Thanks,
Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Q on SELECT column list pushdown from view to table
Next
From: Alexandru Lazarev
Date:
Subject: Re: Is pg_basebackup Performance Limited by Files Page Cache?