John Sales <[EMAIL PROTECTED]> writes:
> By doing this, I'm hoping that the query optimizer is smart enough to see
> that if a query comes in and requests only the six columns (that are in the
> narrower table) that PostgreSQL won't have to load the wider table into the
> buffer pool, and thereby actually have to only access about 10% the amount of
> disk that it presently does.
> Is this a sound theory?
No. It still has to touch the second table to confirm the existence of
rows to join to.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
