Re: Partitioned tables as a poor mans columnar index?

From: marcin mank <marcin(dot)mank(at)gmail(dot)com>
To: Peter Hunsberger <peter(dot)hunsberger(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Partitioned tables as a poor mans columnar index?
Date: 2009-10-16 20:31:23
Message-ID: b1b9fac60910161331s6c759663ie511f533fee714f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 16, 2009 at 9:19 PM, Peter Hunsberger
<peter(dot)hunsberger(at)gmail(dot)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 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2009-10-16 20:35:47 Re: [HACKERS] contrib/plantuner - enable PostgreSQL planner hints
Previous Message Christophe Pettus 2009-10-16 19:51:20 Re: contrib/plantuner - enable PostgreSQL planner hints