Jan Wieck wrote: > Tom Lane wrote: > > > Jan Wieck <[EMAIL PROTECTED]> writes: > >> Okay, my proposal would be to have a VACUUM mode where it tells the > >> buffer manager to only return a page if it is already in memory, and > >> some "not cached" if it would have to read it from disk, and simply skip > >> the page in that case. > > > > Since no such call is available at the OS level, this would only work > > well with very large shared_buffers settings (ie, you try to rely on > > PG shared buffers to the exclusion of kernel disk cache). AFAIK the > > general consensus is that that's not a good way to run Postgres. > > Oh-kay ... so yes Manfred, your RSM is probably the better way.
Added to TODO. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])