Re: Fixed length data types issue

Gregory Stark wrote:
> This is most obviously the case for data warehouses that are doing
> lots of sequential scans of tables that don't fit in cache.

In a data warehouse, you won't have many caching effects anyway.

> But it's largely true for OLTP applications too. The more compact the
> data the more tuples fit on a page and the greater the chance you
> have the page you need in cache.

But a linear amount of more RAM is still more affordable than a CPU that 
is 100 times faster, which is about what some of the proposed schemes 
would require.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/