Until the underlying system memory allocator fails and then it go boom. How much goes boom is OS dependent. Some OSes will only allow the errant process go boom. Others (such as those from Microsoft) the entire OS go boom if the out of memory condition encompases the entire V=V address space.
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin >Sent: Tuesday, 19 December, 2017 11:12 >To: SQLite mailing list >Subject: Re: [sqlite] What happens if an in memory database runs out >of memory > > > >On 19 Dec 2017, at 6:01pm, curmudgeon <tam118...@hotmail.com> wrote: > >> 1) I read in those links that each temp table is given (by default) >its own >> page cache of 500 pages. Is this a separately created page cache or >is it >> 500 pages from THEE page chache? If it's the latter that will >explain the >> slowdown for cache_size < -500. Or does the cache_size pragma >dictate the >> size of the separately created page cache? > >Each temporary table gets its own cache. > >It works like this: Each attached file gets its own page cache, with >a size governed by SQLITE_DEFAULT_CACHE_SIZE and/or "PRAGMA >cache_size" . Each temporary table declared is considered to be a >separate attached file. > >> 3) Similar to the original question, if you set temp_store = 2 >(memory) and >> there isn't enough memory for the table what happens? > >By 'memory' that web page is referring to whatever your operating >system thinks is memory. So the same thing happens as would happen >to any application which tries to use a lot of memory: the virtual >memory mechanism kicks in and memory is swapped to and from disk. > >Simon. >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
