[GENERAL] Partitioned tables as a poor mans columnar index?

2009-10-16 Thread Peter Hunsberger
I just realized that my replies to my previous question on sparse arrays went off list due to the way this list server is set up (sigh). It has occurred to me that for my problem, one possible solution is columnar indexes and that, in a way, partitioned tables in Postgres might give me somewhat

Re: [GENERAL] Partitioned tables as a poor mans columnar index?

2009-10-16 Thread marcin mank
On Fri, Oct 16, 2009 at 9:19 PM, Peter Hunsberger peter.hunsber...@gmail.com wrote: The basic problem I have is that I have some tables that are potentially very long (100,000's to millions of rows) and very skinny, and I end up with maybe a total of 12 bits of data in each row. Are You

Re: [GENERAL] Partitioned tables as a poor mans columnar index?

2009-10-16 Thread Peter Hunsberger
On Fri, Oct 16, 2009 at 3:31 PM, marcin mank marcin.m...@gmail.com wrote: On Fri, Oct 16, 2009 at 9:19 PM, Peter Hunsberger peter.hunsber...@gmail.com wrote: The basic problem I have is that I have some tables that are potentially very long (100,000's to millions of rows) and very skinny,