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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to