Robert Haas <robertmhaas@xxxxxxxxx> writes: >> so I think that it is much easier for the database engine to efficiantly >> search two 500G tables instead of one 1T table. > And that leads me to the opposite conclusion on this point. I don't think there would be any difference on that score, either. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance