>>> On Tue, Oct 16, 2007 at 3:43 PM, in message <[EMAIL PROTECTED]>, "ssurui" <[EMAIL PROTECTED]> wrote: > use top command observe the available memory top is not the best way to look at RAM usage. Try free or other tools. > I find about 500MB memory is > vanished after the SQL is executed. Meaning that it is used by the OS cache? That would make sense, given that you just read all the data pages for the table. -Kevin
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
