2010/5/27 Cédric Villemain <cedric.villemain.debian@xxxxxxxxx>: > 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? -- Konrad Garus -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance