Search Postgresql Archives

Re: Partitioned tables as a poor mans columnar index?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Oct 16, 2009 at 9:19 PM, Peter Hunsberger
<peter.hunsberger@xxxxxxxxx> 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 aware that there are some 20-ish bytes of metadata for each
row? saving 4 bytes buys You nothing. Give it up.

Also, these are actually pretty small tables (i.e. they fit in memory
of any non-toy server).

Greetings
Marcin

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux