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
I find that partitioning does work, but it requires extra
care on the part of the application developer that really
shouldn't be necessary.
In response to
pgsql-general by date
|Next:||From: Dmitriy Igrishin||Date: 2010-11-12 21:29:48|
|Subject: Re: More then 1600 columns?|
|Previous:||From: Dann Corbit||Date: 2010-11-12 21:10:41|
|Subject: Re: More then 1600 columns? |