On Wed, 2 Jun 2004 07:18:00 +0000 (UTC), Gary Benade wrote:

> I have a server running WinXP Pro with 750mb of ram
> When I restore a database the server maxes out on ram, with only about
> 20K of memory free. This starves my server apps that are trying to serve
> clients connected on other databases.
> db size doesnt really matter, but my databases are around 1GB,
> The server is configured for 20000 8kb page buffers, which means firebird
> should not use more than 160MB of ram for the restore. I did notice that
> a large part of the ram is being used by the system cache - what causes
> this?
> The machine is configured for background process priority and memory
> usage favours programs in performance settings

Maybe creating indexes uses sorts which are handled in memory until it is
(nearly) exhausted (when it will start using files in the TEMP directory).

--
Aage J.