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/