2010/5/27 Konrad Garus <konrad.ga...@gmail.com>: > 2010/5/27 Cédric Villemain <cedric.villemain.deb...@gmail.com>: > >> well, that is the projection of file in memory. only projection, but >> the memory is still acquire. It is ok to rework this part and project >> something like 128MB and loop. (in fact the code is needed for 9.0 >> because segment can be > 1GB, I didn't check what is the optimum >> projection size yet) >> So both yes at your questions :) > > So when I map 12 GB, this process will consume 1 GB and the time > needed to browse through the whole 12 GB buffer?
Exactly. And the time to browse depend on the number of blocks already in core memory. I am interested by tests results and benchmarks if you are going to do some :) > > -- > Konrad Garus > -- Cédric Villemain 2ndQuadrant http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
