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/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
