"Peter T. Brown" <[EMAIL PROTECTED]> writes: > But how can Postgres be 'forced' to keep a table in memory? I've noticed > that on our Dual Pentium4, 1GB RAM machine, the size of the individual > postgres threads is very small. Top reports it as like 5K or 20K (I believe > that's what it means). Shouldn't this number be 100's of MB if postgres is > properly moving my tables to RAM? I do notice that the system cache is very > very large...
System cache == RAM. This is the behavior you want. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])