On Fri, 12 Nov 2010 21:10 +0000, "Dann Corbit" wrote: > If (for access) the single table seems simpler, then > a view can be used. Even if you "partition" the columns in the instrument over N tables, you still can't query it in a single result set. The limit is quite deep in PostgreSQL and extends to tuples, including views and in-memory query results. I find that partitioning does work, but it requires extra care on the part of the application developer that really shouldn't be necessary. Best, Clark -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
