Re: Questions about horizontal partitioning

[John Sales <spelunker334@xxxxxxxxx>]

Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

John Sales 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

Good point..

What if I made the second table optional using an outer join, so as not to imply the existance of rows in the "wide" table?

thanks

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com