On Thursday 25 Nov 2004 6:22 pm, Richard Huxton wrote: > > On the other hand, if an application has to "fight" against the file > > system, I would suppose it to increase RAM and CPU usage > > significantly. > > It shouldn't be fighting the file system, but it does use it, and rely > on it for caching (rather than bypassing your filesystem cache). For > MS-SQL server I'm guessing you're allocating a lot of memory to SQL > server and not much to the file-cache. For PG you'll want it the other > way around.
Do we have some sort of document about how caching on windows works? It is very simple on linux and BSDs but for other OSs, I haven't seen many suggestions. I am sure OS specific hints would help OP a lot. Shridhar ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match