svanderclock wrote:

> hmm, how 100 000 page buffer can make me run out of physical memory ? with 4ko page buffer, it's only 400 mb of memory and i have 4gb on our test machine.
>
> but anyway that was a good remarque (and a good guess) and it's look logical. how to know if a program go into a memoy disk swap hell ?

Given the information I've got, guessing is the best I can do.
But do remember that the page cache is not the only thing on
the system. The server uses memory for other things - like the
lock table, sort buffers, metadata, etc. And you might even
have another program running.


Cheers,

Ann