2010/5/27 Konrad Garus <konrad.garus@xxxxxxxxx>: > 2010/5/27 Cédric Villemain <cedric.villemain.debian@xxxxxxxxx>: > >> pgmincore() and pgmincore_snapshot() both are able to mmap up to 1GB. > > Does it mean they can occupy 1 GB of RAM? How does it relate to amount > of page buffers mapped by OS? 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 :) > > -- > Konrad Garus > -- Cédric Villemain 2ndQuadrant http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
